Forum Discussion

DanaDana's avatar
DanaDana
Qrew Cadet
8 years ago

Duration Formula with If Statement and Checkbox

I have a duration field that I only want to calculate if a checkbox is checked. I have the following formula but it's still calculating a duration even if the condition isn't met: If(ToText([NTO Re...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Is your checkbox field [NTO Resolved in Field]?

If so, try this:

If([NTO Resolved in Field]=false, null, [Contractor Resolved Date]-[Creation Date])

...