invalid column value error
System
Employee
This discussion was created from comments split from: If And Formula , Return a date.
Answers
-
Hi @Andrée Starå!
I am trying to use the principals of this formula with different columns, but I tried copying and pasting the exact formula from this thread first and it is not working for me.
If I replace the ([Realized Date]@row+90) with "True", the formula works.
Thank you for your help!
-
Can you double check your column types?
Both "Realized Date" and the Formula column will need to be Date type of columns in order to add 90 days onto the Realized Date.
Let me know if that helped!
Cheers,
Genevieve
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!