Date range formula help

@Paul Newcome looking for your expertise again!

I'm looking to automate/expatiate our time keeping process to pay subs. I've had no luck after a few hours, so figured I'd reach out. See the screen shots below. The goal is to have a each employee and their total weeks pay consolidated on a line based on a specific date range. I'm totally open to adding/removing any columns. I'm thinking it's going to be along the lines of this, but I'm striking out =SUMIFS({HDZ Red plant labor Range 1}, {HDZ Red plant labor Range 3}, @cell = [Employee Name]1, @cell >= [Pay period]1, @cell <= [Pay Period End]1)

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!