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.

Accoglienza!

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

Trova più post etichettati come

Commenti

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!

Link veloci

Trending discussions

New Dashboards
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
why does it not show the bars in timeline view like most gantt charts do?
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.
Locked Rows Permit Editing of Dropdown List Columns by Non-Admin Editors
I have reproduced the following behavior in a validated Smartsheet application. User permission: Editor (not Admin) Row status: Locked (confirmed via row menu displaying "Unlock Row") Text, Date, Contact List, and Checkbox columns cannot be modified. Dropdown List columns remain editable. Selecting a new dropdown value and…