Skip to main content

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?


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:



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?

This is great, thank you!

Integration service like Zapier?


Yes, or Integromat, what I like more lately.

Reply


Terms & Conditions