Formula for Previous Workday

AV_NGG

Hello, I've seen some formulas here that are close to what I'm looking for, but nothing that exactly matches. I've created a payroll calendar in Smartsheet and I want to alert a user the workday before the payroll deadline, excluding holidays. The field is [Alert Date]@row.

Thanks in advance!

bisaacs

Hey @AV_NGG,

Is [Alert Date] the day prior to the payroll deadline, or is that the payroll deadline? If it's the day prior, what column is the payroll date stored in? What have you already tried in terms of formulas?

AV_NGG

The field [Alert Date]@row should be the workday prior to the field [Date]@row. I assume =WORKDAY(Date@row, -1) should do it, but do you know if that takes into account the holidays entered for our org in the admin section?

bisaacs

Hey @AV_NGG,

I believe it does as long as you have dependencies enabled (which can be found in Gantt View, then click the gear in the upper right corner):

Hope this helps!