Help

Re: Return a value when a status is changed

1120 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Candice_Garcia
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

3 Replies 3

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.