Schedule update dates
I'm looking at creating a function that lets the user know when the next review date for a row is, based on the Overall Status (not closed), Last Review Date and Review Frequency columns.
If possible I'd like to use Daily, Weekly etc., to make it a better experience for the user, rather than using the number of days (1, 7, 30 etc.,).
My thoughts are to use a helper column with an IF to select the number of days, then use the helper column value to update the Next Review Date.
- Is there an easier way to do this :-) ?
- Will updating by the number of days work from this year to the next, or would I need to look at incrementing the year, month, week?
- If the Next Review Date falls on a weekend, I want to move the date to the Monday of the following week.
Many thanks for any help.
Help Article Resources
Check out the Formula Handbook template!