Formula for duration
So bad at formulas. How would I change this formula to say if "Completed" or "Cancelled" null otherwise... I have it working for status = completed If([Status] = "Completed", null, ToDays(Today()...
Forum Discussion
Hey Mark,
If the formula is working correctly otherwise, you should just be able to append it like so:
If([Status] = "Completed" or [Status] = "Cancelled", null, ToDays(Today() - ([Due Date])) <= 0, null, Today() - ([Due Date]))
------------------------------
Freddie Sabbs
Senior Solutions Consultant
Quick Base
fsabbs@quickbase.com
Cambridge MA
------------------------------
If the formula is working correctly otherwise, you should just be able to append it like so:
If([Status] = "Completed" or [Status] = "Cancelled", null, ToDays(Today() - ([Due Date])) <= 0, null, Today() - ([Due Date]))
------------------------------
Freddie Sabbs
Senior Solutions Consultant
Quick Base
fsabbs@quickbase.com
Cambridge MA
------------------------------
