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() - ([Due Date])) <= 0, null, Today() - ([Due Date]))
------------------------------
Mark Comish
------------------------------
Question
Formula for duration
This topic has been closed for replies.
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
------------------------------
+1Updated your formula:
If([Status] = "Completed" or [Status] = "Cancelled", null, ToDays(Today() - ([Due Date])) <= 0, null, Today() - ([Due Date]))
Alternatively, you could write it with a case statement:
Case([Status],
"Completed", null,
"Cancelled", null,
If(Today() - [Due Date] <= Days(0), null, Today() - [Due Date]))
------------------------------
Justin Lapier
President (Lead QB Developer)
Synctivate
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.