When a specific value present, calculate date from Created to Date of completion

LMou

For other sheets, we use formula

=IF(ISBLANK([Manually Actioned By]@row), NETWORKDAYS(Created@row, TODAY()), NETWORKDAYS(Created@row, [Manual Actioned Date]@row))

to tell us the turnaround time for the activity. It might not even be a great formula but it does what I need.

But now, want to only trigger this where Status@row = Failure (from several options available in dropdown). The AI generated formula's aren't working, so appreciate any help.

Paul Newcome

The easiest way to add something like this is to just wrap the whole thing in another IF.

=IF(Status@row = "Failure", existing_formula))

Paul Newcome

The easiest way to add something like this is to just wrap the whole thing in another IF.

=IF(Status@row = "Failure", existing_formula))

LMou

Thank you!! In my frustration, I hadn't used "" which is why my previous attempts didn't work! All good now. Thanks again 🙌

Paul Newcome

Happy to help. 👍️