Today minus a date field
Options
allison.bastone24911
✭✭✭✭
What am I doing wrong?
=Today()  [Column 5]@row
Column 5 is a date field.
This is giving me an #DATE EXPECTED error
Answers

Make sure that when you hit enter on the cell your lower case is converted to all caps. The formulas are formatted as follows:
=TODAY()  [Column 5]@row
The #DATE EXPECTED error is defined as follows:
Formula Error Messages  Smartsheet Learning Center
Check that your Column 5 is formatted to a date and not defined as a text/number:
 Right click on the column header
 Select Edit Column Properties
 Select Column Type "Date"
 Optional: You will want to click restrict to dates only

Thank you! Although I had everything about as you outlined...I realized my formula would not be returning a date...so I needed to move the formula to a text/number field in order for it to work. Thanks for the brainstorm!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!