=[Date]@row + 7 is showing up as invalid column value
Hello Smartsheet Community!
Can someone please help me with this formula? I'm trying to calculate 7 days after my Date column, however the most common way stated in previous discussions I'm getting an #invalid column value. Please help!
Best Answer
-
Hi @Bellina Bui,
Per the Formula Error Messages Help article, the #INVALID COLUMN VALUE error message appears when a "formula contains or references a data type that is inconsistent with the column type where it is inserted." Check to make sure "Column13" in your sheet is set as a Date column by double-clicking the column header. In the Edit Column Properties window, if anything other than Date is selected, change it to Date and see if this removes the error and produces the expected date value.
With a referenced date of 09/08/20, entering =Date@row + 7 in another date column should give you a result of 09/15/20.
I hope this helps!
Thanks,
Ben
Answers
-
Hi @Bellina Bui,
Per the Formula Error Messages Help article, the #INVALID COLUMN VALUE error message appears when a "formula contains or references a data type that is inconsistent with the column type where it is inserted." Check to make sure "Column13" in your sheet is set as a Date column by double-clicking the column header. In the Edit Column Properties window, if anything other than Date is selected, change it to Date and see if this removes the error and produces the expected date value.
With a referenced date of 09/08/20, entering =Date@row + 7 in another date column should give you a result of 09/15/20.
I hope this helps!
Thanks,
Ben
-
@Ben G THANK YOU BEN!!! It worked :D
I can't believe I didn't think of this earlier.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!