I want to take a smart sheet and have a reminder date column. East task that I have I want it to calculate off the duration to give me a reminder to do the task. Ex:
Send pricing → Nov 1 of the year before the class
Send brochure → 6 months before class date
Check website for class → 90 days before class date
Check in for attendance → 45 days before class date
Send email for travel → 30 days before class date
Send class materials → 7 days before class date
Follow Up → 7 days after class date
I have all of this listed out in the primary column with indentions under the primary state I am doing this for.
Ex: Washington
Send Pricing
Etc.
I have about 25 states I have to put on this spreadsheet due to different timings and I don't want to use a calendar for this and have to calculate this all by hand. Is there a way to make this happen?
