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 ✓


    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!