Getting field value

ndontisrinivasa

I wanted to check if there is a way i can check on a certain column, if the value in the cell matches the value i need, provide me the value from another cell in the same row.

JamesB

@ndontisrinivasa

The if statement below is what you need.

if([Reference Column Name]@row="VALUE",[Value Column Name]@row," ")

ndontisrinivasa

I tried this =IF({Moderna Study Details Client Facing Range 2}@row = 1, "yes", "no") with range being checkboxes. System is saying #unparsable; I also tried putting "1". Then i tried different column range and put specific value for that also getting same error

Andrée Starå

Hi @ndontisrinivasa

I hope you're well and safe!

Are you checking it in the same sheet or two different ones?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

ndontisrinivasa

This is a different sheet, so i am referencing it.

Andrée Starå

@ndontisrinivasa

Then try removing the @row part.

Did it work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Ace012

This question is very similar to what I am hoping to do too. However, I would like to pull in a specific value from a list that corresponds to the value entered. For example, if a store # = 0323, then pull in the group # that is next to that store # in a list (i.e. 290). Using the formula above it will pull in the group # if it's on the same line but it's not referencing a list.

I was able to find a formula for excel (shown below- user enters "store #" and sheet populates the correct "Group") but just haven't been able to find the right one for Smartsheet yet.

I am also in favor of using a reference sheet and have it set up but not sure on how to link it when I'm still working on getting the formula right. Any help would be much appreciated!!

ndontisrinivasa

@Andrée Starå when i remove @row it says invalid operation.