if formula

inon rettig

hi

trying to make a condition

if "approved" is "yes"

but "charged" is "no"

i want the flag to red on risk column

thanks

Andrée Starå

Hi @inon rettig

I hope you're well and safe!

Try something like this.

=IF(AND(Approved@row = "Yes", Charged@row = "No"), 1)

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

inon rettig

Andrée Starå

Hi @inon rettig

I hope you're well and safe!

Try something like this.

=IF(AND(Approved@row = "Yes", Charged@row = "No"), 1)

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

jhonalbert

In If condition we have two results one is Yes in which they execute to the true and other is No in which they not execute to the true one or break the statement.

inon rettig

inon rettig

@Andrée Starå thanks alot

can i bother you with another one?

if "invoice payment" is in the past but "payed" is "no" then "flag"

Andrée Starå

@inon rettig

You're more than welcome!

Try something like this.

=
IF([Invoice Payment Date]@row <> "", IF(AND([Invoice Payment Date]@row < TODAY(), 
Payed@row = "No"), 1))

Did that work?

inon rettig

@Andrée Starå

thank you very much

i feel like ill have to start paying you soon 😉

but seriously you are helping me a lot and I thank you for that

Andrée Starå

@inon rettig

😀

I'm always happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!