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

PR12x3
PR12x3 ✭✭
in Formulas and Functions
image.png

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

· Share on FacebookShare on Twitter

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

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!