nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Utilizing a Checkbox in a sumifs equation

Craig Ward

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

Dynamic View - additional features
following functionality in dynamic view would be impactful: freeze column - in the settings but also controllable by the viewer Choose filters to share from the original Smartsheet sheet In detail panel settings, being able to universally apply a setting like “read only” while also still making individual choices to change…
Changing backup download save location
Hi I am trying to download my backups and when I click "Download Backup" it sends the download to my downloads folder. There is never an option or prompt to ask me which folder I want these saved to. I want to download them directly to a hard drive, I download a lot of backups and there isn't enough room on my computer to…
Link to Download Attachment Missing
Hi, I have automations in place to generate various documents, based on the form completed. Once the document is generated, the user WOULD receive an email that included a message I create and then a link (at the very bottom) for the recipient to click on to download the generated document. Now, I still get the email but…