-
Autopopulate Cells Else New Entry
I am trying to create a New Order Entry form. I have a dropdown list that references our customer sheet. If the customer is not listed, you can choose "(NEW CUSTOMER)", which allows more fields to open up to add the new customer info. If the customer is listed, can I have the address autopopulate into the appropriate…
-
Changes made to column titles
Automated flow when a cell or row changes exist already. I want to notify a person when the title of a specific column changes as it will effect dashboards that refer to the column title.
-
Dynamic Dashboard Filters
I would like to add two dynamic filters as a widget within my Dashboard to define a date range (start and end date) which would then return a count value to that same Dashboard. I have been searching for answers but am not coming up with the solution I'm looking for. What is the cleanest way to configure this?
-
How to do cell linking in new Smartsheet lauout
Trying to link cell from other sheet and I'm not finding the symbol for it in the toolbar. I have the new layout. Anyone know have to do that?
-
How to trigger an action from one Smartsheet to another
I'm working on 2 Smartsheets right now and am trying to create a formula between the two. My first Smartsheet document is called "Stores in Progress." The 2nd Smartsheet is called "Ready for Service." In my "Stores in Progress" Smartsheet, I have a checkbox column called "Ready for Production." I want to design it so that…
-
Master Project Plan
I have a massive project that spans across multiple regions. I want to segregate my plan into region sheets so when I update each individual plan the master plan will be updated. How can I do this?
-
In Control Center: Link Assigned to, to Project Team on Intake
I have Control Center. We are set up to where the project team is not entered when a new project is created. The column is there, but the requestor doesn't necessarily know how the project team is. As we build out the project plan, I would like to have everyone that is "Assigned To" a task, auto-populate the Project Team…
-
The "Master Program View" (Dynamic Sheet Aggregation)
Problem: Current Limitations Reports are "Flat" Lists: Current Reports can aggregate rows from multiple sheets, but they function as static lists. They cannot perform project logic (dependencies, duration calculations) across those sheets. No Cross-Sheet Critical Path: There is no native way to identify a "Critical Path"…
-
Adding YTD totals without using Sheet Summary fields
I have a sheet the tracks manufacturing operations. Each year, I need to summarize YTD totals from the sheet. This is resulting in many sheet summary fields each year. As time goes on, I will run out of the limit of 200 fields. Is there a way to automate any of this, either with automation or having information go to…
-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…