Getting Unparsable Error

vishalpandey

Hello Everyone,
I am having an issue.
I am using the below formula on a column to populate a value.
=IF(CONTAINS("507737 - Rachel Hawley", [Fellow 1 BIN]@row), [Fellow 1 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 2 BIN]@row), [Fellow 2 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 3 BIN]@row), [Fellow 3 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 4 Bin]@row), [Fellow 4 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 5 BIN]@row), [Fellow 5 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 6 BIN]@row), [Fellow 6 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 7 BIN]@row), [Fellow 7 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 8 BIN]@row), [Fellow 8 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 9 BIN]@row), [Fellow 9 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 10 BIN]@row), [Fellow 10 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 11 BIN]@row), [Fellow 11 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 12 BIN]@row), [Fellow 12 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 13 BIN]@row), [Fellow 13 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 14 BIN]@row), [Fellow 14 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 15 BIN]@row), [Fellow 15 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 16 BIN]@row), [Fellow 16 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 17 BIN]@row), [Fellow 17 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 18 BIN]@row), [Fellow 18 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 19 BIN]@row), [Fellow 19 $ Share]@row, IF(CONTAINS("507737 - Rachel Hawley", [Fellow 20 BIN]@row), [Fellow 20 $ Share]@row, Total@row))))))))))))))))))))))))))))))))))))))))
I am using the above formula to copy the value of respective Fellow Share to a Row if their name is on that Fellow Bin.
For Example If 507737- Rachel Hawley appears on the Fellow 9 column, I want the value of Fellow 9 Share to be copied to one other column where I am entering this formula.
It gives me an Unparsable error. Is there anything I need to do differently here?

NickStaffordPM

Honestly your best bet is use the AI features within Smartsheet for formula creation to help find your issue OR ask ChatGPT to be your Smartsheet SME and go back and forth with it to improve the formula. Checking the synthax of that formula would be INTENSE just given the number of terms and embedded IF statements.

heyjay

Without testing all the nested if (I jus ttried the first two), looks like there are all the same, formula looks OK. If you just added the Total column, try to enter your formula again. That is the only way I was able to replicate your error.

Just also make sure that all columns exists with the exact name.