How to connect statements with conditions?
Howdy!
I am new in the business and i'm trying to connect some statements on my sheet, so I'll apreciate if anyone can help me with this :)
=IF([PROGRESS]2 = 1, "Green" (Status)
Now
IF today is greater than one day of the [due date]1 , "Red"
IF [STATUS]1 IS GREEN should be green even if due date is greater than "today"
Meanwhile [STATUS] should maintain "Gray"
I hope I have made myself understood
Many thanks!
Best Answer
-
Hi @Diego Cardenas
Hope you are fine, please try the following formula and convert it to column formt formula:
=IFERROR(IF(PROGRESS@row = 1, "Green", IF(AND(PROGRESS@row < 1, [due date]@row > TODAY()), "Gray", "Red")), "")
the following screenshot shows the result
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Diego Cardenas
Hope you are fine, please try the following formula and convert it to column formt formula:
=IFERROR(IF(PROGRESS@row = 1, "Green", IF(AND(PROGRESS@row < 1, [due date]@row > TODAY()), "Gray", "Red")), "")
the following screenshot shows the result
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
-
Excellent, have a nice weekend 😀
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
Check out the Formula Handbook template!