Return a value when a status is changed



I’m looking for a way to track whether projects completed by team members were done so early, on time or late. I have a column that uses a single select drop down option for them to change their status when they proceed to the next portion of their project (On Deck, In progress, etc).

Is there a way that I can set up a formula to track when a task goes from one status to the other, compare the date it was changed to the due date (also set up in a column using the date field) and return a value of either early, on time or late?



You need a integration service for that, but it’s easy to do.

Then you can set a Formula to do this part. There are some threads like this:



This is great, thank you!
Integration service like Zapier?



Yes, or Integromat, what I like more lately.

1 Like