-
How can I auto-populate a formula in a column that is referencing values in another sheet?
I have the formula below that is referencing the Planned Date and Exit Shop Date, but when I drag the formula through the column it doesn't update these dates as well? What I want to do is as I drag the formula down a row I also want the Planned Date and Exit Shop Date to move down a row and not remain static Is this…
-
Unable to run workflow
I have a workflow that generates a document when another field is checked off, however, I keep getting the following error and have no idea how to troubleshoot and fix the issue. "This workflow was triggered by at least 5 other workflows, which exceeds the maximum allowed. Please modify the workflows that are interacting…
-
Why doesn't the column filter work in "Get a sheet data (dynamic schema)"? [Power Automate]
Setup: Configure dynamic schema block to extract only one column: Expected Behavior: The Power Automate Block returns an array of my rows with only the selected column values included. Issue: All columns are included, notwithstanding the setting. Here you can see at least 2 columns, but take my word for it that there are…
-
Automated Workflows not triggering
I have a sheet that collects responses from a form and when a row is added, a workflow should then be triggered to record the entry date. This would then trigger another workflow to copy the rows to another sheet and nothing… Even though the criteria are met, the workflows are not triggering and IF it does, it takes a long…
-
Automated Document Generation and DocuSign mapping is here!
Hi Community, Smartsheet customers can now accelerate their processes by automating the creation of documents and DocuSign mapping within Smartsheet. With this new workflow action for document generation and DocuSign mapping, process owners can reduce manual steps for their team when generating invoices, purchase orders,…
-
Numerical value established by a formula not seen as a number
Hello I have used the mid formula to break down a date and indicate the number of the month only in a field. =MID([Start Date]@row, 2, 1). This is all working fine. I want to run an automation where if the value of this field is less than 5 do x. However it is not seeing the value as a number and is thus returning zero…
-
Automations Dilema
My team implements software applications. Often the application we install consists of numerous 'parts'. Each 'part' has an accompanying build sheet: We use Control Center to stand up a project and it will contain all or most of these sheets. We have automation on the sheets when a date is missed. The problem is the…
-
Do Not Email Notify Triggering User from Workflow Automation (PMO)
How can I stop my automations from copying the triggering user via email? The automation itself works great for letting the inteded person know they've had a task row assigned to them via email - but the triggering user does not want to be copied on said notification. I've searched the community for answers - I've been…
-
Smartsheet alert 3 days before the first Thursday of the month
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