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!