Using Date within formulas to calculate Harvey Balls with duo criteria



I am stuck on making the following formula work in my project plan.

1) Using the flag symbol, I am trying to calculate: IF the status = 'To Do' AND the date is today or in the past then FLAG otherwise no FLAG.

I have a 'Status' column with the following values: To Do, In Progress, Done, Closed, On Hold

I have a 'Projected Start Date' column that specifies when that task is set to start.

Best Answers

  • Teresa Mardones
    Answer ✓

    Thank you!! I am from Canada so the second formula worked for me.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!