Created Formula but it is not performing as I thought

Adriane Price

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?

David Tutwiler

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.

David Tutwiler

What does the Move Row automation look like?

Adriane Price

The automation is turned off, I currently only have the formula that is shown in the picture =DATEONLY([Next availability]@row) + 30

David Tutwiler

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.

Adriane Price

okay I will delete the automation and see if that does the trick.

Adriane Price

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!

David Tutwiler

@Adriane Price Great to hear! Glad it's working.