If Formula help

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
[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?
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Sorry Numeric for Weeks to Exhaust, Exhaust Month is the date field
Please give an example of what result you expect for  some example data.
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
Try:

If(IsNull([WEEKS_TO_EXHAUST]) or [WEEKS_TO_EXHAUST]=0,"",

If([WEEKS_TO_EXHAUST]<0,"-",

ToText([EXHAUST_MONTH])

))
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Thank you I have  the formula working but I will add the "or", that way I wont miss anything