Formula and dates
Patricia Worth
✭✭✭
Hi all
I have a date column that is a formula (10/12/18 + 60 = 12/11/18) I need to add 6 months to that date, but when i try to add 182 to the 12/11/18 date i get Invalid Column Value. What am i doing wrong?
Comments
-
It sounds like your column property is set to Text/Number. If you click the arrow underneath the column header it should say Current type: Date at the bottom. If it doesn't you can Edit Column Properties there.
-
figured it out... the column was not a date column... all good now.. thank you!
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