How to select a column of dates


I have a column of report due dates (date) and I am trying to create a column that gives the number of dates until each different report is due. I have tried =date:date - TODAY() which does not work. It works when I specify the cell [date]1-TODAY(). I need this to display for each row.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!