Uploading from Excel. Cells with formulas showing #UNPARSEABLE
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
Best Answer

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?
Answers

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!!!

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!