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 tex...
Forum Discussion
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.