Count Function not working

It looks like you might have 2 spaces after ONB in the formula but only one space in the data you are evaluating.

Hey Paul,

Thank you for the quick reply, unfortunately that was not the issue as it is also for the value "Local Sales ONB".

Not sure why these are not getting counted any other ideas?

Double check the column data as well. Smartsheet will only display one space even if there are multiple spaces, but it can affect your counts when you start referencing the data in formulas.

The two cells in the below screenshot are a copy/paste of each other to show what I mean. The data itself has five spaces between the letters, but when I am not actively editing the data only one space is shown.

I am also not sure what you mean by "also for the value "Local Sales ONB"". I don't see that in your formula or anywhere in the screenshots.

Thanks Paul, it doesn't look like there are any extra spaces after the value in the drop-down, shown in the picture below for the "ONB - No Reply by VAR" field.

Screen Shot 2020-06-16 at 2.54.50 PM.png

Other status fields that are unable to be counted are:

Waiting for VAR Response - 0
NS- Waiting for VAR Response - 0
Local Sales ONB - 0
Complete - Handover to VAR - 0
No / Incorrect Email Address in PPE- 0
Rejct-Deny-Exprd-Inactive in PPE - 0
Not Submitted in PPE - 0
Approved - No Sell-In Country - 0
ONB - No Reply by VAR - 0
PPE - No Reply by VAR - 0

Below please find some screenshots of filters run on two of these statuses pulling results, so it shows their numbers should be higher than 0.

Screen Shot 2020-06-16 at 3.00.11 PM.png

Screen Shot 2020-06-16 at 2.59.38 PM.png

@Andrée Starå Do you have any ideas on the above?

Thanks Paul and Andree, for some extra help

Approved - ONB to Start - 170 and koC Scheduled - 3 are the only fields in the status collumn that aree able to be counted.

@Paul Newcome

Strange!

Hmm!

Can you try changing the column name(s) to one word and update the formula and try if that works?

Did it work?

Hey @Andrée Starå, thank you for the quick reply. Which columns? The columns in the COUNTIF formula is already one word, "Status".

It's been a long day! 😉I meant the words that you're counting. Change all of them to single words to see if they work.

I'd recommend saving a copy of the sheet and test it in the copy.

Hey @Andrée Starå, thanks for the help, still not having much luck. Is there any additional information I can provide you that might help figure out a reason for this?

Happy to help!

I'd be happy to take a quick look!

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hey @Andrée Starå , This problem is fixed, not sure why but today formulas are grabbing, maybe a caching issue?

Glad it's working for you now. I have seen instances of complex/larger sheets taking a while to update correctly.