- Repeated reminders for no response to update request
Hello, is there a way to set up notification for reminding the update owners to complete their updates until they are done? For example, the due date is 12/10 and the update owner hasn't updated the status. I would like to send them daily reminders until they have changed the due date and/or update the status.
- After "Save As' from a worksheet, why does the MS Teams alerts have to be reset every time?
For our software's deployments, we use a checklist. There is a template and it is 'save as' before kicking off the next deployment process. There are e-mail automations and MS Teams automations. The e-mail automations stay the same but the Teams automations have to be reconfigured to the Team and Channel each time. Is this…
- Automated Move Rows won't move anything
I have an automation set to run whenever a "Status" row changed (or row is added) with a condition: "Where Status Contains 'Out of Service'". It's set to alert me, then move rows. It alerts me just fine, but won't move any rows. Using the row options to move the rows works with ease, and no error messages ever appear. My…
- Workflow to Update Date to TODAY() until another cell = 100%
I have 2 cells in a column: Which displays a % from 1-100 Which should show a date Is it possible to use a workflow or other automation to daily (at 12:01am or any other time) update the date field to TODAY(), but to stop updating it once the % field = 100%? Thanks in advance!
- How can I set a dynamic filter on a report to auto change to today's date?
I have created a report to track upcoming go-lives to display on a dashboard, I currently have a filter that specifies an exact date, but is it possible to have a filter that pulls in data for a date 30 days before todays date or even today's date? For example, a condition that will say Original Go-Live is greater than…
- Auto calculate the estimated date of completion
Hello, I want to auto calculate the estimated date of completion based on the current status and pending work items in the backlog.
- Change Cell Value not working
My sheet has a Start Time Column and End Time Column. Both are single select 'Restrict to dropdown values only' I also have an "All Day" checkbox column This sheet is populated with the use of a form On the form, I have logic to only show the Start and End times when All Day is not checked. I'm trying to populate the Start…
- Copy Rows Automation: only copy select columns?
Hi Smartsheet Community, Is there a way to set up the Copy Rows workflow in such a way that it will only copy select columns to a second sheet? Certain staff will be inputting information into 14 columns on a spreadsheet, but I only want 12 of the 14 columns to copy to a second sheet, as two of the columns may contain…
- Formula to show Current Status of Project Approval
Not sure if this would be accomplished easier with a Formula or with a Update Cell Workflow. We have a Projects Smartsheet that have 4 different Reviewers that need to approve. I'm looking to add another column for Reporting purposes that will show what approval step each project is on. For example, based off my attached…
- How record a date automation work?
嗨,我是使用r有困难ecord a date automation. as you can see in 1st picture, I create record a date when "send noti to slack" is checked in 2nd picture, every change I made in that check box is from 25-Nov-2021 but record date show 24-Nov-2021 does anyone know why? and what I have to do to make it record the…
