Welcome!

Utilizing a Checkbox in a sumifs equation

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

Find more posts tagged with

Comments

Mike Wilday

Can you paste in the formula you currently have in the cell that is causing the error?

Craig Ward

what method would you suggest to accomplish this?

Mike Wilday

Just double click on the cell providing the error and then copy and paste the text of the formula into this community thread.

Craig Ward

Please attachment below

thanks

smartsheet checkbox.png

Craig Ward

=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)

thanks

Andrée Starå

Hi Craig,

Are the ranges the same size?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

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.

Andrée Starå

Nice catch!

Paul Newcome

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

Mike Wilday

Haha. I love it when I miss the obvious.

Sign in to join the conversation!

Quick Links

Trending discussions

What is the best way to create a form, where you want to capture info on multiple occasions?
We are creating a three part learning series for HCP's and want to use one form to capture information presented during each visit. Is it possible to use a logical sequence only shows once each visit is entered? (Ex. Date 1, xyz presentation, then Date 2 is available to populate to enter xyz presentation) Or would I need…
iCal to Outlook - Filtered Calendar?
I have a sheet that collects information relevant to multiple people, think of these items as task assignments. I would like to have this integrated into each individual's Outlook calendar, but I want to filter it only to what pertains to them, is this possible? I understand it can't be done from a report. I also…
Hyperlinks Not Working
I have a weird situation. I have a hyperlink to a SharePoint site in a column. Each line has a different link. When you click the link, it does not work. When you copy the text and paste it in the browser, it works. I confirmed that the link text and the display text are the same. Any suggestions?