Combining Multiple IF(AND) Formulas.
I have studied the Smartsheet Community boards but am unable to get my formula to work. My goal would be to combine the following rules into 1 formula:
- If the "% Complete" column is 100% then leave the "At Risk" flag unmarked.
- Mark the "At Risk" flag if the "Start" date was passed and the "% Complete" is less than .1 (10%)
- Mark the "At Risk" flag IF the "Finish" date has passed and the "% Complete" is less than 1 (100%)
Please see attached screen shot showing my columns and Formula
Thanks in Advance!!
Best Answers
-
Hi @Kendrick Hanny
Hope you are fine, please try the following formula and convert it to column formula:
=IF(AND(Start@row < TODAY(), [% Complete]@row < 0.1), 1, IF(AND(Finish@row < TODAY(), [% Complete]@row < 1), 1, 0))
screenshot show the result
bassam.khalil2009@gmail.com
☑️ 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"
-
bassam.khalil2009@gmail.com
☑️ 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 @Kendrick Hanny
Hope you are fine, please try the following formula and convert it to column formula:
=IF(AND(Start@row < TODAY(), [% Complete]@row < 0.1), 1, IF(AND(Finish@row < TODAY(), [% Complete]@row < 1), 1, 0))
screenshot show the result
bassam.khalil2009@gmail.com
☑️ 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"
-
Wow! Thank you! Worked great.
-
bassam.khalil2009@gmail.com
☑️ 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!