Sign in to join the conversation:
I want to set up a reminder to occur 6 weeks prior to an event. The pull down menu choices of timing give me a maximum of 4 weeks or 30 or 60 days? How do I schedule it 6 weeks or 42 days prior to the event?
Thanks!
Hi,
You'd need a so-called helper column that for example, would have the formula to calculate the date or check a box if it's 6 weeks prior to the event date.
Would that work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
JH
Just base your alerts on a second date column that adds a number of days, eg 30/46/60 to the actual date.
RichardR
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…
