Setting a 5 Day before Date formula

JassoN
JassoN ✭✭
in Smartsheet Basics

I have a Smartsheet with a working formula

image.png

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

image.png


· Share on FacebookShare on Twitter

Answers

  • Todd M Keller
    Todd M Keller ✭✭✭✭

    Hello, a couple of questions, Are you the Admin of the sheet? Is the target column restricted to dates only?

    · Share on FacebookShare on Twitter
  • JassoN
    JassoN ✭✭

    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.

    · Share on FacebookShare on Twitter
  • Todd M Keller
    Todd M Keller ✭✭✭✭

    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.....

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video