Setting a 5 Day before Date formula
I have a Smartsheet with a working formula
But when I try and apply the same formula to a different Smartsheet I am receiving an error. Both columns are Dates...Any idea what I am doing wrong? Receiving Invalid Operation
Answers
-
Hello, a couple of questions, Are you the Admin of the sheet? Is the target column restricted to dates only?
-
Hi @Todd M Keller ! Thanks for taking the time. I am Admin on both sheets. I have tried both restricting and not restricting to dates only. The working formula does not have 'restricted to dates only' as an FYI.
-
Interesting..... The only way I could get an error was to restrict to dates only. Also, I have run into some strange issues if I don't save and reload the sheet. You could try protecting the entire formula in parenthesis......
=([Mirror EAD]@row - 5)
Also, just in case, change it back to a cell formula for troubleshooting.....
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives