Sign in to join the conversation:
Unable to resolve a SUMIFs utilizing a checkbox as a trigger in another sheet. attempted to paste screenshot of formula here with no luck. Unparseable is the only result i can get
please help
Craig
Can you paste in the formula you currently have in the cell that is causing the error?
what method would you suggest to accomplish this?
Just double click on the cell providing the error and then copy and paste the text of the formula into this community thread.
Please attachment below
thanks
=SUMIFS({2020 SLS Advertising and Marketing Plan Range 1}, {2020 SLS Advertising and Marketing Plan Range 2}, "true", [2020 SLS Advertising and Marketing Plan Range 3}, [Promo Type]1)
Hi Craig,
Are the ranges the same size?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
You have a square bracket instead of a curly bracket opening your Range 3 reference. Try switching that out and see if that works for you.
Nice catch!
Funny thing is... I didn't catch it when I looked at the pasted formula in the post above. It wasn't until I zoomed in on the screenshot that I noticed it. Haha
Haha. I love it when I miss the obvious.
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
