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.
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
Hi, I am getting conflicting information from Chat GPT and Copilot on whether I can change the time zone for my system time stamps. I have Pacific time showing up. We are in Eastern Standard Time. I have my setting in my profile set for Eastern Standard time, but it doesn't seem to change the created time stamp and the…
By when the issue will be resolved?
