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!