I know I am over thinking this but I am trying to figure out 2 week look out.
Lets say Start date 7/20/21 and I want Smartsheet to give me an alert 2 weeks before. What is the correct set up in Smartsheet?
Try setting it to run based on the date field and then set the condition to be when that date field is in the next 14 days.
If that doesn't work, I usually insert a date column and then use a formula to populate the date I want the automation to run on then set it to trigger based on this new date column. In your case the formula would be
=[Start Date] - 14
In the Trigger, do I put it at "2 weeks before"? Also, what do I set in the Conditions?
Actually I would change the trigger to "Custom" and set it to run daily. Then in the condition portion change "is greater than" to "is in the next" and type in "14".
I believe I have it correct.
That looks right to me. Is it working?
Yes. Its been working. Thank you.
Excellent. I'm glad its working for you.
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.