-
worflows not working anymore today
Hi, I've set up some basic workflows on a sheet (Trigger: When rows are added, Actions: Lock a row, Copy a row), they have been reliable for a long time and until yesterday evening but this morning none of them are working. I have checked that the sheet were the rows were copied was not full. When I manually copy the rows…
-
Any ideas on why the pivot app does not update with new data in the source?
I have a pivot sheet set up to pull data in from a report. The initial set up worked perfectly and when I run the configuration manually, the data is pulled in. But when the runs hourly (Update Frequency is set to 1 hour), no updates are made. All config logs show "Success!" but new data is only added to the pivot sheet if…
-
Automated Workflow - Recurring Notification based on Date Field
I have a sheet where I need to have a notification sent to a team every 6 months from an entered Start Date. On my sheet, I have the Project Name, the Project Status, and the Project Start Date. It seems in the workflow setup, the only triggers are when a row is added, changed, or when a date is reached. My instinct tells…
-
Need to count workdays too in the formula how can i do that?
=[Due Date]1 - TODAY() How can I make this formula in a way that it only counts working days and not Saturday and Sunday
-
Show all the recipients on an email alert
It would be great if possible to show on the c/c part of an email all the recipients copied on alerts. I have many users requesting to have such functionality in Smartsheet alerts.
-
Trigger workflow based on time of day a request is received
Hello Community! I have a question I wanted to bring to the table... I've been working on some processes and workflows for triaging work on my team. Requests come in through an intake form and we have automations to assign to specific resources based on the type of project/request that it is. Now, we are trying to make…
-
Multiple workflows in a worksheet - "This workflow was triggered by at least 5 other workflows"
Hello all, I'm currently having a sheet with the answers from one survey form (30 questions). The answers are YES/NO option, but then I would need to convert the YES and NO in 1 and 0. What I did (and maybe I overcomplicated myself) was to create 1 workflow per column. When a new row is created then this triggers the 1st…
-
Request an update
I'm thinking of setting up an automated request an update workflow to go out to the assigned column once a week every Friday to manage the construction phase of my project. Only trouble is I want it to send an individual email to each contact in the assigned column not one big email. I have been setting up a weekly…
-
Automation Workflow Not Consistently Working
Hi! I set up an automation workflow on a form I created in Smartsheet. I have tested it twice; with one group it worked and each person received the email notification to approve or deny, however, the other group no email notifications were received to take action. I did not update the workflow between test groups and the…
