I have set up a workflow in one of my sheets to have the source location as "OneDrive & SharePoint" and then selected the file from a specific folder. In this folder, a new report is posted weekly and I would like the workflow to select that new report each week to update the workflow. Is that possible? I know you can do…
This discussion has been merged.
We have a process where someone should perform some checks every 3 days and use a Smartsheet form to fill out the results. We want to send a notification if those checks have not been done in 3 days. I created a helper column. When the form is submitted the value is true. I created a workflow that if the Date completed of…
I have a sheet that is accessed by many reporters. Each of the 500+ row is cleared with a checkbox to indicate it can be sent through to a Power BI report. If the box is unchecked, that content is removed from the next report refresh. Can you suggest the best way to set this up so that the report continues to show…
Hi Team, The Requestor/ initiator is not someone who would have access to the SS tracker. The person would simply update the required fields and submit the form for next step of approvals. I have build the form for 4 approvals levels and it works fine when each level just hit APPROVE and not decline. However, if one hits…
I am building an inspection sheet and form where our operations team will be able to mark pass/fail through a checklist. If something "fails", I want that specific row in the inspection sheet to be copied over to another project tracking sheet. These two sheets will necessitate different fields. Upon the specified…
I would like to be able to use Smartsheet groups as recipients within automation workflow notifications instead of listing each user individually.
Hi Team, I have created a 4 tier linear approval workflow wherein the functionality works fine when we go through the Approve option for all levels. However, if the first one declines and the forms opens up at requestor level for update and they submit it….from their the next approver gets 1. multiple requests/ email…
Or, will I have to manually add that workflow to each sheet? Background - I want to set an automated workflow reminder whenever a date is past due. Easy enough. However, we have 73 individual Project Manager sheets that I need to create the same workflow for. I would prefer not having to open 73 sheets and manually create…
Automations are being deactivated when saving new sheet as... or setting up as a template. Generate Documents or Document created from document builder and Send to specific contacts are samples. Is there a way, without getting additional subscription, to prevent this from happening?