Is there a way w/o having to create a date column and just list the first Thursday of each month manually to send an alert 3 days before. I know I can send one for each 1st Thursday but I need the alert to go off a few days before. Thank you
Hi, I am trying to set up an automation where it detects when a date found in column DATE is passed and then would automatically update it based on the value found in the column frequency for example : if the DATE = 01/07/2021 and the frequency = Weekly then when we pass the date 01/07/2021 it should automatically change…
I want to alert the project manager of any changes to records managed by that project manager and include only the values of the fields that changed. The fields that were modified could be 1 or more of dozens. So I do not want to include ALL fields -- only those which have been modified. Is that possible?
Hi, I am fairly new to smartsheet so I apologize if this is a basic question. I am trying to automatically populate a contact column with a single contact indefinitely. For context, it's just so that in a separate report that pulls from many sheets, a filter that only allows a row assigned to a contact to be shown can be…
Hello, I currently am trying to automate a process but having few issues:I currently send out an email manually to send their top 3 accomplishments, top 3 issues for last week etc. I am trying to automate the sending out email. I want to keep the historic data but do not want multiple columns with each week. Is there a way…
I'd like to be able to have the dates in a column update based on the Sprint number. So, I've created a new sheet with one column with the Sprint # and a column for the associated dates. I have a column in my main project spreadsheet titled Sprint #. I'm having trouble figuring out how to tie it all together. I've been…
I have set up a sheet that lists every web page on my company's site and has a column listing the Content Partner who is in charge of that page. I have a workflow that alerts the Content Partner annually to review their pages. Often, one Content Partner will be listed for multiple web pages in any given month (because they…
Can anyone advise what happens when you have move row automation running but your destination sheet is full? I assume the workflow stops until a new destination sheet is added in the automation logic? Many thanks!
I would like to send an alert to someone when any field in the row changes, except comments. How can this be done without having to set an alert for each column individually?
Hi, I've been trying to figure out how to create an automation send Alert email to resources who haven't submit their status for the day. Can you help me or suggest on how am I able to achieve this? Thank you.
