Formula for Date to Round to upcoming Fridays Date


Good Morning,

I am looking for help in creating a formula that will automatically update to the following Fridays date. You will see in the screen shot below that we have the auto column for the date request form submitted. I am looking to have the ordered date automatically round to the Friday following the created date. So in the example below the created date is 10/9/23, and I would like for it to automatically round to 9/13/23, how do I make this happen?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!