Sign in to join the conversation:
I'm basically trying to search for X text within my Email column to average out the monthly data. Can someone please advise what i'm missing cause it's driving me insane, haha. I know it's gotta be something simple.
Hi,
The range has to be the same.
Try something like this.
=SUMIF(Email1:Email10; $Primary3; Delivered1:Delivered10)
The same version but with the below changes for your and others convenience.
=SUMIF(Email1:Email10, $Primary3, Delivered1:Delivered10)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
what a life saver!!! Where in the world is this documentation?
Lifesaver! Wow! Thanks!
Happy to help!
Look here for documentation/help:
https://help.smartsheet.com
https://help.smartsheet.com/functions
Andrée
Hi everyone, in several of my Details Views for multiple Dynamic Views, text fields and/or checkboxes that are configured in the Dynamic View settings are not appearing in the Detailed View. Is anyone else seeing this today? I've not updated any of my configurations lately and don't know how to explain this! Thanks!
The timeline widget has a toggle: Set the default hierarchy state. I am turning on "expand lanes by default." It seems regardless if I turn this "on", save, sign out, and sign back in, it automatically changes back to "off" when I log out. I have tried clearing my browser cache.
Can someone tell me how to get rid of the 120.0% max on this graph? It is always going total 100% and never any more, so I would like to use more of the space for graph display purposes. I even tried reducing it so that the largest value was 99.999%, thinking maybe being exactly 100 would cause the next "level" to…
