Return a value when a status is changed

#1

Hello,

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?

0 Likes

#2

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:

0 Likes

#3

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

0 Likes

#4

Yes, or Integromat, what I like more lately.

1 Like