Sumif between dates in different columns

Neil Spencer
Neil Spencer ✭✭✭
edited 12/09/19 in Formulas and Functions


I have a sheet with the following columns "Resource required", "Shift", "Date From" and a "Date To".  What i need to do (Probably on another sheet) is sum the resource column against the criteria in the shift column and for a given date for the whole sheet.  Any ideas or help would be greatly appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!