Sign in to join the conversation:
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.
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
