Forum Discussion

EvoAdministrato's avatar
EvoAdministrato
Qrew Trainee
7 years ago

Calculated Column Formula

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
  • JimHarrison's avatar
    JimHarrison
    Qrew Champion
    7 years ago
    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.