Returning a cell value if false

artaylor

Hello all.



Pretty new to Smartsheet here. I am trying to create a call that checks if one column, Trip, contains a value 1st, if it does NOT contain the value 1st, I want it to populate the contents of the corresponding cell in column Job Description.



I keep running into errors attempting to nest the cell call =[Job Description]1 in an IF statement.

 

=IF(Trip1 = "1st", " ", =IF(Trip1 = "2nd", =[Job Description]1 , =IF(Trip1 = "3rd" , =[Job Description]1)))

is probably the closest, as far as I can tell, to what I need, but I still cannot make that =Cell1 call work in a formula. Does it require special brackets? I have tried square and parentheses and I saw somewhere that curly brackets are for specific data views regarding editors.

 

Any time I try to add the call for another cell into the formula it gives an invalid operation. Is there a workaround for this?

 

halp

Andrée Starå

Hi,

Try this.

=IF(Trip@row = "1st"; ""; IF(Trip@row = "2nd"; [Job Description]@row; IF(Trip@row = "3rd"; [Job Description]@row)))   

The same version but with the below changes for your and others convenience.    

=IF(Trip@row = "1st", "", IF(Trip@row = "2nd", [Job Description]@row, IF(Trip@row = "3rd", [Job Description]@row)))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day & Happy Holidays!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

artaylor

This works AND it shows me the syntax, which I needed for future efforts. Thank you so much!

Andrée Starå

Great!

Happy to help!

Best,

Andrée

Paul Newcome

=IF(NOT(Trip@row = "1st"), [Job Description]@row, "")

 

Would this work as well? It is basically saying that if Trip contains anything other than "1st", to pull the Job Description value, otherwise leave blank.

It seems like this might provide more flexibility as you wouldn't have to account for any additional possibilities if there should happen to be a "4th", "5th", etc... with what could end up being an excessively long nested IF statement.