Duration Formula
Help! While fairly new to "fun" with formulas, I am trying to calculate a simple duration. I've got field "Date Advisor Received" and "Date Completed" Both are Date Type fields. I've added another fie...
Forum Discussion
Hello Jamie,
For calculating simple duration, We have "Formula - Duration" as field type available in Quickbase.
Few changes required here are :
Hope it resolves your problem. Looking to hear back from you!
------------------------------
Pranav Choudhary
Quickbase Expert Builder Certified by Quickbase
beniwalpranav@gmail.com
------------------------------
For calculating simple duration, We have "Formula - Duration" as field type available in Quickbase.
Few changes required here are :
- Change field type of "Days Open/Advisor Actively worked" to formula - duration.
- Formula Modification :- If([Status]="Complete", [Date Completed] - [Date Advisor Received] , Today() - [Date Advisor Received])
Hope it resolves your problem. Looking to hear back from you!
------------------------------
Pranav Choudhary
Quickbase Expert Builder Certified by Quickbase
beniwalpranav@gmail.com
------------------------------
Worked like a charm! Thank you so much :)
------------------------------
Jamie Strauss
------------------------------
------------------------------
Jamie Strauss
------------------------------
