Need help with formula.

Trudy

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?

Kelly Moore

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

https://help.smartsheet.com/articles/2476816-create-cell-column-reference-formula

https://help.smartsheet.com/function/countifs

https://help.smartsheet.com/function/or

cheers,

Kelly

Kelly Moore

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

https://help.smartsheet.com/articles/2476816-create-cell-column-reference-formula

https://help.smartsheet.com/function/countifs

https://help.smartsheet.com/function/or

cheers,

Kelly

Trudy

Thank you Kelly, i was looking at Learning Center yesterday and did try to follow, i will get better :)😅