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
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!