Added TODAY() to a formula that works and get an error

Goal is to have a symbol represent how much newer the forecasted date is to TODAY. Any help would be much appreciated.

Best Answer

  • JamesB
    JamesB ✭✭✭✭✭✭
    Answer ✓

    @PR12x3


    Your Today call in your first syntax is incorrect. instead of AND(Today), it should be AND(TODAY()

    You also do not need @row after the Today() function. Today is pulling from your local date on your workstation

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!