Options
✭✭
edited 12/09/19

Hi All:

I have three columns [RUN/INVEST], [MUPOR] and [CHECK] in my sheet. I also have two separate data sheets SHEET1 and SHEET2. And I want to write an if else formula as below for [CHECK] column values

if ([RUN/INVEST]1 = "Invest") then

{Look for [MUPOR]1 value in column1 of  SHEET1, if found there, then [CHECK]1 = "Invest FOUND in SHEET1" else "Invest NOT FOUND in SHEET1"}

elseif ([RUN/INVEST] = "Run") then

{Look for [MUPOR]1 value in column1 of  SHEET2, if found there, then [CHECK]1 = "Run FOUND in SHEET2" else "Run NOT FOUND in SHEET2"}

else

( [CHECK]1 = "NEITHER INVEST NOT RUN")

Is this kind of formula possible to develop in smartsheet. thanks for your help.

thanks

Sushil

Tags:

• ✭✭✭✭✭✭
Options

It seems like you are trying to display multiple values in the [CHECK] column?

I'm kinda of confused with what exactly you are trying to accomplish.

You want to look in Sheet 1 for the word "Invest" based off of what is in the [MUPOR] column of your 3rd sheet? If it is there in sheet 1 then you want it to display a specific phrase, but if it is not found then display something else, but if "Run" is found on sheet 2 then display another specific phrase, otherwise display yet something else, and if it is not found in either then display this final phrase?

Is sheet 1 always going to say "Invest" and never "Run" and sheet 2 always say "Run" and never "Invest"? What if it is found on both sheets?

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!