Date field minus 'TODAY()

Lachlan Stead
Lachlan Stead ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello All,

Could someone please explain why the following doesn't work or a solution:

I have a date column with a mix of dates both past and future. The next column is a column to say how many days till this date occurs. Therefore if it is in the future (i.e. date is the 30/10/20) then the second column needs to say 534. If it was it the past (i.e. date is the 13/11/18) then the second column needs to say -183.

I have managed to get it working in excel with a simple formula in the second column '=DATECOLUMN-NOW()' but unfortunately '=DATECOLUMN-TODAY()' won't work in SmartSheet.


Thanks in advance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!