Welcome!

Formula help

Hi,

I am trying to count the total in a range on another sheet if entries fall within a certain date range (30 days) and are a specific name "Missed Hours"

I have the following formula but cant get it to work:

=SUMIFS({Help Desk Range 1}, <=TODAY(), {Help Desk Range 1}, >=TODAY(-30), {Help Desk Range 2}, "Missed Hours", {Hours missed})

Help desk range 1 is a cross sheet date range, Help desk range 2 is a cross sheet category range and Hours missed is a cross sheet field where the hours are entered and this is what i want to total.

Looking for total hours missed within the last 30 days if anyone can help please.

Find more posts tagged with

Comments

L_123

Your range to sum should be at the beginning of the statement, not the end.

=SUMIFS({Hours missed},{Help Desk Range 1}, <=TODAY(), {Help Desk Range 1}, >=TODAY(-30), {Help Desk Range 2}, "Missed Hours")

https://help.smartsheet.com/function/sumifs

Also make sure your ranges are all the same length/contain the same amount of references, this is a common issue.

dave.mcpherson56751

Thank you very much, that works a treat.

Still getting used to formulas so help is greatly appreciated.

Dave

Sign in to join the conversation!

Quick Links

Trending discussions

Using single-sign-on with external partners
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…
Cannot create new Chart from a report
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…
Anyone have the link to register for the Core Product Exam without the Learning Pass.
Cant find this anywhere