-
Auto populate a summary sheet.
Is there a way to auto populate the averages of values which meet a certain criteria into a summary sheet? I was hoping to create a filter function in the source sheet, import the filtered data into the summary sheet than potentially calculate the averages of said data in a way that allows the summary sheet to update asโฆ
-
files management
I have 3 different divisions organized in three files, i just wanna put all the data of the tree files in another one and show them in a pie chart or in a similar chart where i can see and manage the entire situation, does anyone know ho to do that? another question, is better keep the 3 divisions in just one file? or keepโฆ
-
Copy a new text entry to another sheet without duplication
Hi Smartsheet Community, Dummy scenario is: I am using a smartsheet form to survey people on what their favourite colour is? Since any responder can enter any colour or shade, I don't have the colours pre-defined. The survey captures the responses into a database, from which I will do my analysis and dashboard. How can Iโฆ
-
Why is my Index Collect formula not working?
My source sheet contains information associated with clients, including site locations, managers, addresses, email, and phone numbers. My destination sheet includes rows with that site information. In some cases, a client has multiple sites. To capture all of the sites (rows) associated with a particular client, I added aโฆ
-
Unique data and sort row function
Hi, I have a customer base with one customer appearing 4 to 5times and have values across them. I want to create unique customers and represent their values in chart format. And every time a new customer is added, their value appears with the sorting Ascending or Descending. I have tried using Report with sorting function.โฆ
-
Validate information from user form
I am trying to see if there is a way that I can validate a ID number on the form that checks the sheet. So if someone enters their ID on the form wrong, it validates that and tells them this is not correct or not found. Is this possible?
-
Calculating completion date from multiple turn around time and date assigned
Hi All, I have created a workload management sheet. Within the sheet 1 column is for Turn Around Times (there are multiple) and 1 column is for Date Assigned. I need to calculate the Completion Date from the Turn Around Time and Date Assigned: Date Assigned + Turn around Time = X. What is the best formula to use? Thankโฆ
-
Update a copy row
Hello, I have a form that is feeding a master sheet, with an automation to copy rows to separate sheets assigned by state. I'm looking for a way to update the information so that it stays consistent on the master sheet and the separated sheet where the row was copied to. The only solution I can think of is to have anโฆ
-
Status Rollup to Parent
I've seen some very similar solutions to my problem, but not quite what I am looking for. My Smartsheet plan has a status column and is using dependencies. My choices in the status column are (Not Started, In Progress, At Risk, and Complete). I would like to create a formula that automatically rolls up the parent of eachโฆ
-
Running formulas on data within cell history
Is it possible to run a formula (specifically NETDAYS) on the dates contained in cell history?