If ([WEEKS_TO_EXHAUST]=0,"", If ([WEEKS_TO_EXHAUST]<0,"", [EXHAUST_MONTH]))
I can not get this formula to work, please help
Weeks to Exhaust is a date field
 490 Points
Posted 3 years ago
QuickBaseCoach App Dev./Training, Champion
 65,462 Points
[WEEKS_TO_EXHAUST] does not appear to be a date field. Are you sure about that?
What Field type is [EXHAUST_MONTH]
Can you explain in regular English words with an example of what the formula is trying to do?
What Field type is [EXHAUST_MONTH]
Can you explain in regular English words with an example of what the formula is trying to do?
 490 Points
QuickBaseCoach App Dev./Training, Champion
 65,462 Points
QuickBasePros_IDS, Champion
 3,772 Points
Try:
If(IsNull([WEEKS_TO_EXHAUST]) or [WEEKS_TO_EXHAUST]=0,"",
If([WEEKS_TO_EXHAUST]<0,"",
ToText([EXHAUST_MONTH])
))
If(IsNull([WEEKS_TO_EXHAUST]) or [WEEKS_TO_EXHAUST]=0,"",
If([WEEKS_TO_EXHAUST]<0,"",
ToText([EXHAUST_MONTH])
))
 490 Points
Thank you I have the formula working but I will add the "or", that way I wont miss anything
Related Categories

Formulas & functions
 2931 Conversations
 75 Followers