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?
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!
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Just base your alerts on a second date column that adds a number of days, eg 30/46/60 to the actual date.
I would like to have my note column auto size so that the note when longer then the cell it in, can be read in its full txt and not disappear under the next column
Good day Smartsheet Support How do I Riana this account user change my account credentials to another username and password. I am not using this account, but my college is using this account with my credentials. Can you please assist me in how to go forward by changing my account credentials to another users' credentials.…
Is it possible to have a Chart Widget that is currently populated, maintain the same attributes (specifically the chart type and even series/colors) whenever the data source is updated? Example - I have a sheet that lists in one column different Business Purposes. In the next column, is a formula that counts how many times…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.