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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!