Condition with formula dependent

(0) Share

Report

Posted on by Dougers1

Hi My flow has a Condition that requires to - Non Compliant - if this matches the user gets a email sent, my issue is that the column where condition checks is dependanat on result of formula

=IF(T2>=TODAY(), "Compliant", "Non-Compliant")

this is stopping my flow from sending the email - if i take out formula and type in Non Compliant it works but as the sheet will be marked up daily with new expiry dates i require this formula - is there a fix for this

my sheet

Categories:

Business Process Flows

All responses (2)

Answers (0)

Dougers1 95 on at

Like (0)

Report

Condition with formula dependent

Perfect - that worked :-)
Suggested answer

eetuRobo 2,351 on at

Like (0)

Report

Condition with formula dependent

Are you sure that you have written the condition correct?
I can't be sure but it looks like there is a space between Non and the dash. Like so: Non -Compliant

And then ofcourse it would not match the "Non-Compliant" in the Excel. Maybe change the condition to be Contains or Starts with: "Non"
Like so:

Also for troubleshooting add Compose that shows what is in the current EHR