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; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

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

Columns in an Excel Attachment Data Upload Auto Added to a Source Sheet
Hi, I am wondering if there is a solution for this scenario: I have a Data Shuttle data upload workflow to a Target Sheet that is updated when a new attachment is added. Question: is there a function/features/workaround like Data Shuttle, Bridge, or a combination of features so that if a new column is added to the Excel…
Do not have access to a sheet I created in another plan
I have downgraded to business but no longer have access to my sheet,i get an error 48,get licensing? How do I fix this? This is a customer contact form so i cant recreate it as the email has been sent?
No Admin Access on Sheet
I have been given access as an Admin to edit an existing sheet but cannot edit columns. I am a System Admin. I am a paid Member. I am able to edit information in the sheet but cannot add a column.