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
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.....
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.