Skip to main content
Question

Calculated Column Formula

  • Apr 3, 2018 6:49 PM UTC
  • 0 replies
  • 49 views
I have a text field that I am trying to sort by if it has text in it or not.

Current formula is:
If([Notes]="", "Needs Action")

What do I need to add to have it call the group of notes with text in the field "Addressed
      This topic has been closed for replies.

      JimHarrison
      Forum|alt.badge.img+18
      • JimHarrison
      • Qrew Colonel
      • Apr 3, 2018 7:30 PM UTC
      Your If statement requires the test, the true and the false. Your test is [Notes]="" - means if the notes fields is blank. The next bit is the true part. IF(Notes]="", "Needs Action", "Addressed) - this says If notes is blank, then needs action else addressed. 
      JVIII
      Thank you!!
      Terms & ConditionsAccessibility statement