can Smartsheet send preworded emails under certain conditions?
Yes. Have a look at the automation workflows. You can specify a trigger (which can be date or action based), conditions, recipient, sender, and message. Have a look at this:
Thank you so much. I have created the workflow now, but it seems to only work when i run it.
How do I make it happen automatically?
You can specify a trigger to run the work flow automatically (in the first box in the automation wizard). This can be date based: every day, week, month, in a certain date, a day before a date, etc. etc. or based on something within the sheet itself: a box being checked a specific value being added to a cell, a new row being added, etc. What do you want to trigger your automatic emails?
I want the date to trigger the alert, and if I run it, it does. but if I change the date in the smartsheet to test it, it doesnt trigger.
Is my understanding correct? You have a date column in your sheet and have set the trigger to run on that date field. You enter today's date in the trigger column on the sheet. Save the sheet and wait for the email. But when the time of the alert passes, the email is not sent?
That is correct.
I am not the license older, but have Admin privileges to the sheet the license older started for me to use.
Can you check that the time zone that the automation is using is your time zone?
This one of mine sends at 7am on the trigger day in the PST time zone.
I am running VLOOKUP to bring a picture located in a specific row cell over a new sheet cell. The issue is that picture comes as a text (picture name). My ultimate goal is to pull that picture into a dashboard, when trying that, just the text comes If I bring picture directly from the smart sheet where picture is located…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
I have a report that is filtered by a particular folder within a shared workspace... everytime I remove items from that folder the report no longer watches the folder, and it turns into individual items within the folder... Is this common behavior? Has anyone else experienced this behavior recently? I want the subfolder to…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.