-
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…
-
Is there a way to copy or link an attachment from one Smartsheet to another?
I have two smartsheets. The first, Order Sheet, collects submitted order info from a smartsheet form. The second, Shipping Sheet, has shipping info for both submitted and other/autogenerated orders . I am using Index/Match to pull shipping dates and tracking info from the Shipping Sheet into the Order Sheet. I would also…
-
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…