Looking to set Notifications/Reminders beyond the default options

Hello - I'm a bit new to Smartsheet but loving it so far. I have a few columns with dates that I would like email notifications or reminders set up when the following conditions occur:

1 year anniversary from date in cell

5 years, 9 months after date in cell, IF another cell has a certain value

9 years, 9 months after date in cell, IF another cell has a certain value

Is something like this possible? Does anyone do paid consulting to create a script or formula that I could hire?

Thanks

Eric

Find more posts tagged with

Formulas

Email Notifications

Comments

Andrée Starå

Hi Eric,

This is absolutely possible!

I'd happily work with you and help you with setting up a solution but I need some more information to see what would work best for your particular situation.

If you'd like we can book a time for a free discovery call and take it from there. How does that sound?

Have a fantastic day!

Best,

Andrée Starå - Workflow Consultant / Get Done

ericsite

That would be terrific. Please email me at eric@expertfso.com and we can set up a time to talk.

Richard Rymill SBP

Eric

My colleagues and I offer this service and have experience across 100's of Smartsheet clients, plus we have consultants located in the USA like Craig Williams, the top contributor, as well as the UK.

If you just want occasional advice and some formula training we can do that on an ad hoc basis, or if you prefer us to help you design some really smart workflows we do all of that.

Happy to offer a free initial consultation.

Regards

RichardR

Smarter Business Processes.com

Andrée Starå

Hi again Eric,

Have you solved it or do you still need help?

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?