Formula help

dave.mcpherson56751 ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics


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.