Today Formula not working


I am trying to use the formula =TODAY() - [Date Issue Opened]1 to populate today date- start date= how many days open.

When I type in the formula and try to select the row Date Issue Opened it says #UNPARSEABLE. I have tried using various formulas, so I think it has something to do with selecting the Date Issue Opened.

Thanks for any insight.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!