Created Formula but it is not performing as I thought
Hello,
I have created a formula in smartsheet so when a date is met (availability date) the team has 30 days to update the date before it moves to another sheet to be archived. However the date (availability date) comes up and it moves that data, not allowing the 30 days. Did I write the formula incorrectly?
Adriane
Best Answer
-
The date function looks right and, from what I can tell in your screenshot, is functioning properly. My suspicion would be that automation for the move row has something that is triggering the move early.
Answers
-
What does the Move Row automation look like?
-
The automation is turned off, I currently only have the formula that is shown in the picture =DATEONLY([Next availability]@row) + 30
Adriane
-
The date function looks right and, from what I can tell in your screenshot, is functioning properly. My suspicion would be that automation for the move row has something that is triggering the move early.
-
okay I will delete the automation and see if that does the trick.
Adriane
-
Thank you @David Tutwiler it worked, why I did not think of that no clue. I had it disabled but apparently I needed to delete the automation entirely!
Adriane
-
@Adriane Price Great to hear! Glad it's working.
Help Article Resources
Categories
Check out the Formula Handbook template!
