Need help with formula.
Hi,
I am not familiar with how to use formula in Smartsheet as much as in excel. What i need below is to get the count for Submeter AMR or Submeter Manual for Billing Specialist with the name of Arlene.
If i use excel, this is the formula i use to get the result i need :-
=COUNTIF(F:F,"Arlene")&"-"&COUNTIF(W:W,"submeter AMR")&"-"&COUNTIF(Y:Y,"Submeter Manual")
I did try this :-
=COUNTIF([Billing Specialist]:[Billing Specialist], "Arlene")& "-"& COUNTIF([Billing Method(s)]:[Billing Method(s)], "Submeter AMR")& "-"& COUNTIF([Billing Method(s)]:[Billing Method(s)], "Submeter Manual")))
Result I got is #UNPARSEABLE.
Could you please help?
Best Answer
-
Hey @Trudy
Try this
=COUNTIFS([Billing Specialist]:[Billing Specialist], "Arlene", [Billing Method(s)]:[Billing Method(s)], OR(@cell="Submeter AMR", @cell="Submeter Manual"))
In case you're interested, here's some references that may help your formulas in the future
cheers,
Kelly
Answers
-
Hey @Trudy
Try this
=COUNTIFS([Billing Specialist]:[Billing Specialist], "Arlene", [Billing Method(s)]:[Billing Method(s)], OR(@cell="Submeter AMR", @cell="Submeter Manual"))
In case you're interested, here's some references that may help your formulas in the future
cheers,
Kelly
-
Thank you Kelly, i was looking at Learning Center yesterday and did try to follow, i will get better :)😅
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!