Forum Discussion

LauraCarruthers's avatar
LauraCarruthers
Qrew Member
5 years ago

duration between each status change

I have a field called status. It has 3 values: Not started, in progress, complete.  I'm trying to measure the duration between each status.  Is there a simple way to do this? ----------------------...
Formulas and functions
Quickbase Automations
LauraCarruthers's avatar
LauraCarruthers
Qrew Member
5 years ago
Thank you for your guidance!

------------------------------
Laura Carruthers
------------------------------
LauraCarruthers's avatar
LauraCarruthers
Qrew Member
5 years ago
Ok, i feel really dumb but i cannot get this to work.  I created 3 new fields:
  • Date Started (Date/Time field type)
  • Date Completed (Date/Time field type)
  • Current date time (Formula date/time field time) – populated this with Now()
Then setup the automation.  I took screenshots. What am i doing wrong??

------------------------------
Laura Carruthers
------------------------------