-
Can you create an automation to automatically enter links in one sheet to a template?
Currently, we have a sheet created from a form that we add hyperlinks to from a template we create to reflect the project health, status, and then manually hyperlink the template to this sheet. We would love to run an automation that will automatically create a template and automatically enter these hyperlinks to the sheet…
-
Transform rows in columns
It would be very useful to have a function or automation that allows to copy (based on a selection criterion), the values in the rows of a column and transpose them on a single row of another sheet, on a corresponding number of columns. Example: In a source sheet I have a column with an identifier code; I want to copy all…
-
Increased Expiry Limit for Attachments Sent Via Link
We use the PDF generator tool to auto-generate thousands of approval letters each year. We then have an automaton set up to send the letters out the funding recipients. the validity period for the letters is 90 days, but the attachment link that Smartsheet sends expires after 30 days, meaning we get many requests from…
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
Creating an approval form from a submitted user request form
Hi, I have successfully created a form that allows a new user to provide their information, their requested access level, and their supervisor's name. When the new user submits the form, I want another form to be triggered and sent to the supervisor for their approval for the new user. Thus, the form would include the new…
-
Automation Failing
I have a move rows automation that will not run, even if I push it at the single line level. I have a sort of multi level baby database I work with it's built of 5 total sheets with the fifth sheet being a rotating retirement sheet. sheet 1 is where new data is pasted in, once new data is added it's moved to sheet 2 sheet…
-
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
-
Recurring Task Tracker
Good afternoon, I set up a recurring task tracker for use by different groups within my department but am having trouble setting up the recurrence for automation. I would like the automation to begin the 25th day of each month (irrelevant what day of week) and repeat for the next 21 calendar days. As I go through the…
-
Merged: copy/share automations and filters
This discussion has been merged.
-
Merged: Share set of automations between existing projects
This discussion has been merged.