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.
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…
I am trying to send non-Smartsheets users information on forms. I know I can create a publicly accessible and editable link for the overall sheet/form, however, when I set up automated emails with links to the forms, the links to sheets/rows still require a login. Is there any way to get around it so that emails sent…
This discussion was created from comments split from: Generate documents from row data.
