Need Formula with nesting IF's help

Erin McElroy

Hi folks!

Brand new to the community and this is my first help request. I've watched many you tube videos and read as much in the forum as I could about smartsheet formula's, but I just can't figure out what I'm doing wrong. Let me set this up for you:

I'm trying to take names from a column in sheet 1, and convert them to an assigned number in a column in sheet 2. This is the formula that I think I need to be using, and it is working on the very first row in sheet 2, but despite turning it into a column formula, it isn't pulling the data from the rest of the rows on sheet 1:

=IF({L&S Workflow Range 1} = "Erin Mac", "1232862", IF({L&S Workflow Range 1} = "Sha Shaf", "545097", IF({L&S Workflow Range 1} = "Jas Dhi", "1372279", "")))

I watched one video where the instructor successfully nested several IFs without closing the parenthesis so I've tried that, but smartsheet continues to add them in at the end. Help please and thank you!

Adam Murphy

Hi @Erin McElroy It would be easiest to use cell-links to bring the column into sheet 2, then hide it and change your formula to use [Hidden Column]@row instead of {L&S Workflow Range 1}

Hope this helps!

Adam Murphy

Yes the copy/move row automations cannot move a single column, they move the entire row.

In sheet 2, select the first cell in column you want to contain the column from sheet 1, right click and create cell-link, then browse to sheet one and select the first cell in the column and select all the way down the column for the data you want to copy. This should give you all the data from the column in sheet 1, in sheet 2. Hope this helps!

Adam Murphy

Hi @Erin McElroy It would be easiest to use cell-links to bring the column into sheet 2, then hide it and change your formula to use [Hidden Column]@row instead of {L&S Workflow Range 1}

Hope this helps!

Erin McElroy

This make sense, however I am trying to use cell links for other columns that don't need any conversions, and they aren't working for the entire column either. I'll keep poking around, appreciate your answer!!!

Nathan Slatton

@Erin McElroy Is your cross sheet a sing row/cell or refrencing the entire column?

Erin McElroy

Honestly, I'm not sure. I'm brand new at all of this. Additionally, I created a workflow to copy one column from sheet 1 into sheet 2, and it copied all of sheet 1 over! So I'm thinking I'll leave at is and just reference the data in the columns I need per @Adam Murphy's directions.

Thanks everyone!

Adam Murphy

Yes the copy/move row automations cannot move a single column, they move the entire row.

In sheet 2, select the first cell in column you want to contain the column from sheet 1, right click and create cell-link, then browse to sheet one and select the first cell in the column and select all the way down the column for the data you want to copy. This should give you all the data from the column in sheet 1, in sheet 2. Hope this helps!

Erin McElroy

Thank you!