-
Tracking specific changes in a project plan to second sheet for reporting
We have many project plans that are in our portfolio and I want to be able to report from each project plan when a CHANGE is made for only three fields of the many that are on the sheet. The fields are in the sheet summary and then in a formula in the first row of the project plan for reporting purposes. My goal is that if…
-
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…
-
Weekly update request for newly approved rows
Hello, I'm trying to set up a workflow that will send an update request once a week for all the rows in which the status has changed to "Approved" during the week prior to the request notification. The update request should not include rows that have the status "Approved" if the status field for those rows was not changed…
-
SmartSheet Data to Excel Macro OR Any Alternatives?
Hello, I am new to SmartSheet and have been working on a project. Currently, the data I am working with is entered through a form by users and inputted from there into a SmartSheet. The data I am working with is free-text text boxes (so things like comments, etc.) and I was tasked with coming up with a way to sort through…
-
Merged: Save Draft Automations/Workflows
This discussion has been merged.
-
Merged: Trigger a Data Shuttle Action via Automation Workflow
This discussion has been merged.
-
Merged: Copy/replicate Workflows
This discussion has been merged.
-
Alerts to MS Teams: Was working for years, now asking to add organization
Hi all, I have several automations/workflows set to send alerts to MS Teams. The channels are public and the alert settings are unrestricted. They worked just fine for several years. Suddenly, this week I received emails that the workflows couldn't run. When I checked them, the organization was no longer selected. I tried…
-
Can you have a live connector from one smartsheet to another smartsheet?
Is there a way to have live data from one smartsheet to another smartsheet? let's say that one row from the "child" smartsheet is being updated and the "master" smartsheet gets updated based on the values from the "child" or vice versa
-
How can I obtain the URL for a form that is attached to a sheet ?
I need to obtain the FORM URL that is associated with a sheet that is copied via API so that I can populate the URL in a cell. I was reading over the API documentation and cannot seem to find where this is possible. I know this has been asked sporadically and apologies for the duplicate asks, but this seems like such a key…