new to Smartsheet and struggling with If / And Formula

Options

Hi. I'm fairly new user to Smartsheet and struggling with formulas i could create in excel. I have a sheet that will generate a RAG status based on the combined scores of two columns (likelihood and impact) but cannot get my If /And formula to work at all. I am user a separate helper sheet to generate the results. The plans was to then nest all of the results but i can't get the first expression to work, never mind nesting them. Can anyone point me in the right direction please?

I have looked at examples but still don't fully follow them to be honest :-(


=IF(AND({GMSIT RISK REGISTER Range 1}=1,[{GMSIT RISK REGISTER Range 2}=1."G",""))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!