IF AND formula
Hi Experts,
I'm using below function in column "Model count" which works fine,
=IF([helper column]@row = MIN(COLLECT([helper column]:[helper column], [Model Number]:[Model Number], @cell = [Model Number]@row)), 1)
but I would like to add another check upfront. If (Article dev type)@row is NOT "CO", than it should use the above formula otherwise put in a 0.
I tried this but I get below error:
=IF(AND([Article Development Type]@row <> "CO", [helper column]@row = MIN(COLLECT([helper column]:[helper column], [Model Number]:[Model Number], @cell = [Model Number]@row)), 1, 0))
not sure what's wrong.
Thanks for your help!
Answers
-
I think you just have a bracket in the wrong place.
=IF(AND([Article Development Type]@row <> "CO", [helper column]@row = MIN(COLLECT([helper column]:[helper column], [Model Number]:[Model Number], @cell = [Model Number]@row))), 1, 0)
)Have you tried adding 1 more bracket before the ,1 and removing 1 bracket from the end?
Good luck!
Debbie
-
Thanks @Debbie Sawyer
it works!😊
-
Thats great news :D
Getting the brackets in the right place is something I always need to check carefully! Even after years of writing formulae! Smartsheet are good though, as they colour code their brackets so you can see which close bracket relates to which open one. I find that helpful!
Glad this worked for you.
Kind regards
Debbie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!