Calculated Column Formula

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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"
Photo of Evo Administrator

Evo Administrator

  • 130 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Jim Harrison

Jim Harrison

  • 1,768 Points 1k badge 2x thumb
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. 
Photo of Evo Administrator

Evo Administrator

  • 130 Points 100 badge 2x thumb
Thank you!!