Unanswered

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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

eetuRobo 4,161 Super User 2025 Season 2 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

Was this reply helpful? Yes No
Dougers1 99 on at

Like (0)

Report

Condition with formula dependent

Perfect - that worked :-)

Was this reply helpful? Yes No