Formula based on last modified date that skips weekends

Hi there,

I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated).

With that in mind, I was going to build a helper column that looks at the "Last Modified" date and adds 2 days so I can trigger the workflow off of that.

=[Last Modified]@row+2

However, I'd like the formula to be setup so it skips weekends and any holidays that I have setup in the Project Settings for the sheet.

Any help would be greatly appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!