Formula to push only certain rows to a report
Hello! We had contracted with Smartsheet last year to help build out a timesheet. We didn't end up implementing that version for a number of reasons, but now that we've had a a few changes for our non-exempt team pay dates, we are ready to. When Smartsheet helped us build the sheet and report, the timesheet was due 2 days after the end of the pay period and supervisor approval was required. Now the timesheet is due 1 day after the end of the pay period, and the supervisor has been removed from the process. I updated the due dates and removed the supervisor. The original report associated with the timesheet was set to push the current pay period dates to the report, and at the end of the pay period, 2 or 3 days would also push to the report for the overlap between end of pay period and when the timesheet was due. For the current PE 6/30 pay period, the report is already pushing 7/1 into the report (as of 6/20). I can't figure out quite why as the formulas are very complicated to me and we had to do quite a bit of customization considering we are not on the enterprise plan. We would like the report to show only the current pay period rows, with the exception at the end of the pay period in which the report would show 2 days into the new pay period. Hopefully this makes sense. I've published both the sheet and report for editing and am hoping someone can help with the formulas.
Help Article Resources
Check out the Formula Handbook template!