Hello Jamie,
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])
The 1st Date Client Advisor Received comes back with error Field not identified. - this is because in your formula you have two square brackets instead of one.
Hope it resolves your problem. Looking to hear back from you!
------------------------------
Pranav Choudhary
Quickbase Expert Builder Certified by Quickbase
beniwalpranav@gmail.com
------------------------------