Update a Sheets Row When a Date Filter is Met

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of two modules:

Screenshot_2024-03-13_090317

Here is the original sheet

Screenshot_2024-03-13_090304

1. Filter rows that need a status change

This saves you operations on rows that doesn’t need changing

As you can see, I am using the DATETIME Operators “Earlier than” and “Later than or equal to”

2. Update status cell value based on date

After running, status cell is populated correctly

Screenshot_2024-03-13_090319

Give it a go and let us know if you have any issues!

3 Likes