nested formula help
Hi, I've tried multiple variations of this formula and cant seem to get it to work.
If high level status is "inactive" and detailed status is "abandoned", then turn the patent status column to say A
If high level status is "inactive" and detailed status is "closed", then turn the patent status column to say A
If high level status is "active" and detailed status is "pending", then turn the patent status column to say P
Question:
what have I done wrong to get formula error:
My formula (error message = unparseable)
my formula I entered:
=IF(([High Level Status]@row = "Inactive") + ([Detailed Status]@row = "Abandoned"), "A"), IF(([High Level Status]@row = "Inactive") + ([Detailed Status]@row = "Closed"), "A"), IF(([High Level Status]@row = "Active") + ([Detailed Status]@row = "Pending"), "P"))
thanks so much,
Kat
Best Answer
-
Instead of using the "+", you should use the AND() formula. See below:
=IF(AND([High Level Status]@row = "Inactive",[Detailed Status]@row = "Abandoned"), "A", IF(AND([High Level Status]@row = "Inactive",[Detailed Status]@row = "Closed"), "A", IF(AND([High Level Status]@row = "Active",[Detailed Status]@row = "Pending"), "P")))
Travis C, PMP
Smartsheet Leader with 5+ years of SS experience
Let's connect: LinkedIn - Travis C.
If my answer was sufficient, pleaseupvote and mark my response as answered.
Answers
-
Instead of using the "+", you should use the AND() formula. See below:
=IF(AND([High Level Status]@row = "Inactive",[Detailed Status]@row = "Abandoned"), "A", IF(AND([High Level Status]@row = "Inactive",[Detailed Status]@row = "Closed"), "A", IF(AND([High Level Status]@row = "Active",[Detailed Status]@row = "Pending"), "P")))
Travis C, PMP
Smartsheet Leader with 5+ years of SS experience
Let's connect: LinkedIn - Travis C.
If my answer was sufficient, pleaseupvote and mark my response as answered.
-
@MedaUser THANK YOU SO MUCH! I'm a new user so you have no idea how much of a headache you saved me.
-
Happy to help!
Travis C, PMP
Smartsheet Leader with 5+ years of SS experience
Let's connect: LinkedIn - Travis C.
If my answer was sufficient, pleaseupvote and mark my response as answered.
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
- 152 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!