"Next review date" by input/Actioned date not actual date.

Hi, I'm looking for a base formula to create the next review date without having dates everywhere on my smartsheet document.
Basics of the smartsheet - its a document control piece, Names to start / then review date / & then I've got mutiple tick boxes for when a task has been completed. (approx. 40 tickboxes) These need to be done annually, So when they tick the box - I would like to be reminded (Which i can do via workflow process - that isn't the issue) the upcoming ones.
what i want on this sheet, Is per row - The review date will give me the most closest one (From the input date as i don't want hundreds of dates everywhere) - & if possible, to highlight that one or several tickboxes.
Is this possible or is it wishful thinking?
Answers
-
Are you able to provide some screenshots with sample data?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!