I figured out that the IFS formula is not in Smartsheet but I have been unsuccessful it trying to rewrite it in a way that will work. Can someone help me with this?

=IFS(AJ3="X","",AC3="X","",V3="X","",O3="X","",H3="X","R",H3="","")

Thanks,

Tanner

• ✭✭

Hi Tanner, it would be a similar formula but just use "IF" so would be:

= IF('AJ3' = "X", "", IF('AC3 = "X", ""… etc

This image might help:

It may work better to use a CONTAINS function to search the row for "X" so would look like this:

=IF(CONTAINS("X", [Column4]@row:[Column6]@row), "Yes", "")

Hope that's helped?

• ✭✭

Hi Tanner, it would be a similar formula but just use "IF" so would be:

= IF('AJ3' = "X", "", IF('AC3 = "X", ""… etc

This image might help:

It may work better to use a CONTAINS function to search the row for "X" so would look like this:

=IF(CONTAINS("X", [Column4]@row:[Column6]@row), "Yes", "")

Hope that's helped?

• ✭✭

I just realised that I may have misunderstood the question. Is it to do the formula in excel so that it uploads to Smartsheet without breaking? In that case I'm not sure that it can do that.

• Jeremy_D your first answer is what I am looking for. Thanks!!!

• Overachievers

Hi @tayer

Working on the basis that if the H column contains an 'X' it gives "R" everything else returns "", try this.

=IF(H@row = "X", "R", IF(AJ@row = "X", "", IF(AC@row = "X", "", IF(V@row = "X", "", IF(O@row = "X", "", IF(H@row = "", "", "Other"))))))

I stacked the IFs with the only one returning a different outcome and kept the remaining in order so the formula will end upon the first instance of 'X' across the other columns.

Also changed your row 3 refernce to @row if this is to be applied to all rows in a sheet, which is always advisable.

Hope that helps

Paul McGuinness
Central Operations Manager at Care UK

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!