Updating with Zapier…
In general, the way this is done is to use a new record (or new record in view) trigger in Zapier to pick up the record and then an update record action to update it.
Here’s the table:
Ignore the fact that the Upgraded field is already completed (I only took 1 screenshot).
Here is the Zap:
The first step is triggered by a new record - it’e likely in real life that a New Record in View would be more useful:
This is no more complicated really than the type of ifs we are used to in spreadsheets.
The final step is the record update step:
Here we take the record from the first step and update the Upgraded field with the value calculated in the second step.
And that’s it - it certainly took much longer to write up than it took to set up the table and Zap!
Hope this helps!