Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How do I add today's date based on another cells data?
I know I am missing something simpe, but I want to add "todays" date based on a drop down selection of another cell.
=IF(JAN6 = "Paid", TODAY())
When I use this i get the error: #INVALID COLUMN VALUE and if I add in the column and cell it gives me this:
=IF(JAN6 = "Paid", JAN7 = TODAY())