-
API to provision (copy template folders) in SharePoint from SmartSheet
Has anyone created an API app to provision a set of template folders in SharePoint. Basically to copy and rename as required? I think I can do this via MS Power Automate, but a moire direct may be better.
-
Workflow that only triggers manually
I have a workflow that I want to run only on demand. There is a "run workflow now" feature, which is great. But the workflow is required to have a trigger as if it would run automatically and I end up making a trigger condition that I know will never happen. It would be cleaner to have a trigger of "manual only" or "never"…
-
Is it possible to utilize a template in control center that generates new form url in that sheet?
Is it possible to utilize a template in control center that generates a new form url every time the project toolkit is provisioned? We are using a sheet (which is in this template) where the rows are populated via a form. If I use control center now it just overrides the template with every new project that's provisioned…
-
Automatically Organizing Rows into Hierarchy
Hello Smartsheet Community, I am yet another formula-deficient SS user. Looking for insight on a formula or function I can set up, as I asked the AI formula developer tool to create a formula for this request and it stated, "Smartsheet formulas cannot be used to automatically organize rows into hierarchy". I have created a…
-
Changing Finish Date based on % Complete Column to Update Schedule for Predecessor Tasks
Currently in a Project Sheet there is no way to automatically change a Date in the Finish column once the % Complete column changes to 100%. I am trying to have the schedule auto update the predecessors start and end date based on the date the ancestor task actually was completed. There is currently no way to automatically…
-
Update Request using a Form
I am creating a SmartSheet that we will load specific rows to it. I then would alert the contact of their row via Alert Someone workflow. Then the person would have to update a couple of columns/fields in the Smartsheet. Here is my problem: The Update feature doesn't give you an option (that I know of) of formatting the…
-
How can I automate sending emails to a given cell upon changes to a row?
Hi. I am using an Automation workflow template for Alerting someone given a change in a row. I would like to send an email to a given email address in an 'Email' column in my sheet if something in the row changes. I see only the options to send a email to a given contact in the sheet or to prespecfied people, however these…
-
Slack Integration
Hi All, I know we can integrate Slack with Smartsheet to send notifications to Slack. I would like to know if it is possible to use information in Slack Workflow to update Smartsheet automatically. This would involve adding the details of the Workflow into a new row in Smartsheet whenever a new message is posted in a Slack…
-
Is It Possible To Have Automations Triggered By People Visiting The Sheet?
We are building a smart sheet system that includes one base sheet along with several reports that break up columns, depending on which stakeholder is viewing the report. The goal is for no one to actually edit or review the main underlying sheet, but to only view and edit the corresponding reports. Is it possible for me to…
-
Automation field selector
In the automation process, where you can select which fields are sent in an email, it would be great if we rearrange them. If you want to add a recently added field from the grid to the top of the list, you have to remove all previously selected fields and re-add them in order.