-
Need the hyperlink column to be included in the Smartsheet API response.
Need Smartsheet technical expert suggestion or approach to retrieve hyperlink from Smartsheet API The recommended approach to retrieve hyperlink data structure from columns via the API Any specific column type configurations or API parameters that might be required Best practices for handling hyperlink data in API…
-
Why isn't my sheet pulling into a report?
I created a new sheet for my team by replicating an older sheet and now my tasks aren't pulling into my task report or any of my teammates. I confirmed the sheet was selected in my report but it still isn't pulling in. I've never had an issue with this before so would love some advice on troubleshooting.
-
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets…
-
Dropdown List Alternative with Automatic List Update and Dynamic List Features
There have been many requests for improvements to the Dropdown list from Smartsheet Community. The two most typical requests are Automatic updating of the list @Justin Mauzy @Taylor Compton - NOAA Federal Dynamically changing the list of the following selections based on previous selections @Ian Cooper @Mehran Bagherian…
-
How to Implement Dynamic Dropdown among Two Sheets
A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour. I currently run the below script from Python Anywhere on an hourly basis, and I have shared this script so that anyone else can use it as a template for…
-
Dynamic dropdowns - Waterfall request
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
-
Dynamic Dropdown List
Has anyone created a workaround or built a solution that provides dynamic dropdown lists?
-
Automatically add Child Sum to Rows
Hi there. I am working on several sheets that have a column called "Hours" which holds an hour estimate for task rows. I'd like for their parent rows to have a sum like "=sum(children())" so I can see how many hours are estimated for each project. My problem is that while I can manually set this for the rows, these sheets…
-
TODAY Formula Constantly Changing Date to Current Date
Hi - We have a formula in a sheet =IF(Status@row = "Closed", TODAY(), "") That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when…
-
Why is the sheet name not in the browser tab when in Table view?
The sheet name is in the tab in Grid view, but not Table view, making it difficult to locate a particular sheet when multiple tabs are used. Is this a design oversight?