Want to compare values in 3 columns to return a value in 4th column

Trying to sum up all many active projects are over due. Can add up my active projects with formula: =if(and(type@row="project",status@row="in progress),1,0) but now I want to add the criteria of target completion date is late. Tried the following but get the dreaded "unparseable" message...

=if((and("target completion date",(Today())),(type@row="project",status@row="in progress"),1,0)

Best Answer

  • Carson Penticuff
    Carson Penticuff Community Champion
    Answer ✓

    I am not sure I am interpreting your request correctly. Is this what you are trying to accomplish?

    =IF(AND(type@row="project", status@row="in progress", [target completion date]@row < TODAY()), 1, 0)

Answers

  • Carson Penticuff
    Carson Penticuff Community Champion
    Answer ✓

    I am not sure I am interpreting your request correctly. Is this what you are trying to accomplish?

    =IF(AND(type@row="project", status@row="in progress", [target completion date]@row < TODAY()), 1, 0)

  • BJTidi
    BJTidi ✭✭

    Yes, thanks. I don't use formulas in smartsheet much (at all!) and was getting lost with adding a third "look up". Tried that and it gives me the desired result, appreciate the help!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!