Sign in to join the conversation:
Hello,
I created a form and now have all the data i need. However My formula to give me the number of each tea that was voted for has to be accounted for. It seems that my countif formulas are not working correctly. Can anyone help me?
Can you please share the formula you are using?
I have tried a couple different ones
=COUNTIFS([Favorite #1]1:[Favorite #2]52<bigelow: earl grey)
=SUMIF([Favorite #1]1:[If I had to choose a green tea, I'd pick:]52, yamamoto: genmai, [sum_range])
=COUNTIFS([Favorite #1]1:[If I had to choose a green tea, I'd pick:]52, "yamamoto: genmai")
Try that one? It will give you a 1 for every time Yammamoto: genmai appears in the range that you suggested. Because you're looking for that text specifically you have to put it in quotes.
Mike,
No matter the name I give it or specify the value comes back at zero
Are you putting the Countif formula on the same sheet or trying to pull it from a different sheet?
Create a new row at the top and put this in the first Cell...
=Countifs([Favorite #1]:[Favorite #1], "Bigelow: Earl Grey")
Does that return a count?
Hello Mike,
thank you for helping me, but even when I followed your instructions to a T I now get #BLOCKED. very puzzling to say the least.
Hi Juan,
You get #blocked because one of your cells you are referencing might contain an error. Make sure you don't have a formula that is not working in the Favorite column.
https://help.smartsheet.com/articles/2476176-formula-error-messages#blocked
wow,
thanks Mike!
Did that do the trick for you? Glad I could help you out.
Yes Mike, thank you for being so patient.
I'd like to thank Smartsheets for developing that patience in me. You're welcome!
Hello, I face one difficulty trying to transform text in date using DATE formula I want to find the first day of a week based on the week number & year number put in a cell For instance in a cell I find "25-45" FOR Year= 2025 & Week= 45, so I look for the monday of this week that should be the 3rd of nov Step 1 find first…
I have a formula that I have used for years on a sheet and it was working an hour ago and then all of a sudden it just stopped working, I went out the sheet and back in and . The formula is =IF([Shop Order]@row = 0, (COUNTIF((RN:RN), RN@row ))) but instead of returning the value it says #INVALID COLUMN VALUE Got it working…
Hi Everyone, Looking for some assistance on a dashboard report issue I am running into. I have a dashboard with 3 reports added as Web Content. All 3 reports use at 1 common sheet. All 3 reports are published as read only. Users are not shared the underlying sheets. All 3 reports have some form of filtering. 2 of the…
