-
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?
-
Can I Reference Another Sheet in Table View?
I am trying to move more of my Grids over to Table View, but am not able to find a way to reference another sheet in Table View, aside from using the Dynamic Dropdown option, which is not what I need, since I'm working with formulas. Is this available in Table View? I haven't been able to find anything on it.
-
Operations Intake, portfolio & capacity management
I’m a fairly experienced SS user looking for advice or automation tips that have really transformed your workflow. We currently have an intake form submitted by our field team, which populates our master tracker. After submission, managers review these entries and assign them to team members. What are the best practices or…
-
Exchange values from SmartSheet to Resource Management
Hi all, Current situation: I have a sheet with budget data (Budget YAPed column) And now I want to have this budget in Resource Management. Normally this is how I do: Resource Management —> Projects —> Select project —> Project settings —> Add budget (screen below). —> My question: Is there any possibilities to migrate…
-
How to explain Smartsheet?!
Please check this video it can help you to position Smartsheet in your company all credits to . Cicero. The video is generated with GoogleNotebook its awesome i think. We explore why thousands of organizations trust Smartsheet to manage work smarter, not harder. 💡 Key Takeaways: Smartsheet goes beyond spreadsheets it…