-
Send automated email days before a date
Hello - I figured out how to send an email before a specific date but now I can't get it to only provide the information on the row with the current date. For example - I would like a reminder sent out 3 days before, then 2 days before, then 1 day before a date on the sheet. In the email I'd like the topic for that week to…
-
Sending Alert Email based on Contact Column without sharing sheet
I would like to create an Automation to send an email regularly to recipients that are in a Contact column based on some criteria. After setting up the Alert Email it says that I must share the sheet with these people in order for them to receive it. The email contains no information from the sheet other than getting their…
-
Looking to create an automated flow to disseminate data and updates.
Hello! I am looking to create a unique flow that looks like this: Form → Master Sheet → Break out into Individual sheets by qualifier → Any updates to the master sheet subsequently update the broken out sheets → any updates to the broken out sheets subsequently update the master sheet in a loop The long and short is that…
-
Removing Duplicates while also adding together values from other columns
I have a bit of a complex situation. My company uses SAP for purchasing and we pull an open order report weekly to keep track of each of the buyers orders and delivery dates. I've recently set up a Data Shuttle so we can transition from manually editing the report in Excel to a more fully automated report in Smartsheet.…
-
Workflow invalid issue
Hi all, I have a new (and recurring) issue with certain workflows suddenly becoming invalid. For the most part they are not complicated (see example - simple date record when a status changes), and before this year they seemed to work fine. When I re-enable this one, for instance, it will work for a couple of weeks before…
-
Merged: Dynamic Contact lists - User groups to populate dropdown and/or forms to reference user lib…
This discussion has been merged.
-
Merging Columns together from different sheets.
I have two separate sheets, both tracking job #'s. They are different job numbers and I want to bring those numbers over into another sheet with the column title DRR/Job # (the two different job #'s in one column). Essentially we are tracking the amount of different jobs per persons name so I guess also, how can I…
-
FORMULA WHEN THERE ARE MULTIPLE LINES IN A CELL
I have a sheet that has some rows that have multiple lines. I want to use the qty from each line for a summary formula. I have a formula that works when there are only one line in a row, but I get an error when there are multiple lines. Anyone know of a way to do this?
-
INTUIFACE API Intergration
Add compatibility for INTUIFACE user interface software to communicate with smartsheet via API on all platforms, inparticular IOS. Allow requests from origins, Player running on iOS, with the origin capacitor://localhost (capacitor://localhot) If you were using Intuiface on the web, the origin would be further assistance…
-
Copying action while building Automation
Smartsheet should have option to copy a specific action and reuse it within the Automation. This will save a lot ot time of building Automation where repeative action needs to be places under different condition. Similar faicility is available in Microsoft Power Automate where user can copy some aciton and reuse the same…