Combining Multiple IF(AND) Formulas.

Kendrick Hanny

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:

1. If the "% Complete" column is 100% then leave the "At Risk" flag unmarked.
2. Mark the "At Risk" flag if the "Start" date was passed and the "% Complete" is less than .1 (10%)
3. 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!!

Bassam Khalil

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 Khalil

@Kendrick Hanny

You are welcome

@Genevieve P

Thank you for accepting my answer 🤗

Bassam Khalil

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

Kendrick Hanny

Wow! Thank you! Worked great.

Bassam Khalil

@Kendrick Hanny

You are welcome

@Genevieve P

Thank you for accepting my answer 🤗