Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
About Auto Reminders
Hi Community ,I have an Invoice sheet w
i manage i auto Repairs shop on wheels Receivables I have an Invoice sheet tracker
I have an Invoice sheet where I have the following columns
a column "service date " date type
a check column type "send invoice "
a check column " completed "
and Description of service as a text type
"next schedule date " Date column
so my question is here i want to create an If scenario on alerts
=if Description of service contains the word "PM" then it should calculate by the next scheduled date Column a date for 3 month from service date
then i can make a reminder to go back to customer for another inspection 5 days before next scheduled date?
but my main question is how to do the formula to calculate 3 month from service date only if the column contains in the description the word PM
maybe i can do it as a service code any suggestions on how to Proceed?