IF And formula Use
I am using one of the risk register templates provided by Smartsheet and many of the columns "look" set up for automatic processes but there are no formulas existing to actually pull the data to the columns the template suggests. In an effort to solve this gap in function I am trying to write a formula to pull data from two columns and produce a third column.
Column 1 = drop down menu with three choices
Column 2= drop down menu with four choices
In theory I beleived the formula to work would be a nested If function somewhat like this
=IF(AND([Risk Assessment]@row ="Acceptable", [Likelihood]@row = "Improbable") "1", IF(AND([Risk Assesment]@row = "Acceptable", [Likelihood]@row = "Possible") "2", IF(AND([Risk Assesment]@row = "Acceptable", [Likelihood]@row = "Probable") "3"... Continues with all 10 risk options.
and so on and so forth. I get an UNPARSEABLE error when I try to add the AND function aspect so I suspected my error has to do with that integration.
Answers

Hey @Mlwatne
You are missing a comma following the closing of your AND statements.
=IF(AND([Risk Assessment]@row ="Acceptable", [Likelihood]@row = "Improbable"), "1", IF(AND([Risk Assesment]@row = "Acceptable", [Likelihood]@row = "Possible"), "2", IF(AND([Risk Assessment]@row = "Acceptable", [Likelihood]@row = "Probable"), "3"...
Kelly
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!