Discussions

Expand all | Collapse all

Calculated Column Formula

  • 1.  Calculated Column Formula

    Posted 04-03-2018 14:49
    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


  • 2.  RE: Calculated Column Formula

    Bronze
    Contributor
    Posted 04-03-2018 15:30
    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. 


  • 3.  RE: Calculated Column Formula

    Posted 04-03-2018 15:32
    Thank you!!