Setting a Specific Day of the Week in a Timeline


I am creating a timeline template and need the Mid-Campaign report line to always fall on a Thursday. Is there a way to "round" the date to the next Thursday without manually updating it? For example, if the Mid-campaign is supposed to be delivered on a Monday according to the standard timing, it would be adjusted the Thursday later that week.

An example of this timeline is shown below:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!