- Populate a cell with all corresponding values in a multi-select drop down cell
Hello, I have a column in my sheet that is populated by a multi-select drop down in a form ("Violation" column below). Once submitted, the cells in this row will contain at least one, but typically multiple entries from the multi-select drop down. Once submitted, I would like two other cells to populate with the…
- VLookUp Inconsistently Pulling Data
I have a sheet with multiple triggers. Form populates row and assigns a Row ID Client receives a request to update info on that row Once completed, a user is notified to print out the responses for distribution I had to create a work around because there is not a way to nicely print out individual rows Used the VLookUp…
- Save Button For Webforms
Hello Smartsheet, I have seen multiple threads from as far back as 2015 asking for a save button for webform all of which have a general response from employees saying this will get added as a possible future update. it has been about ~2-3 years in some cases. As a user community, this is an important function for data…
- Countifs syntax killing me
I want to count number of projects on hold AND change control = resource constraints This is what I"ve tried; =COUNTIFs([Portfolio Rollups Range 8], "Hold", {Portfolio Rollups Range 9}, "Resource Constraints")
- Analyzing the raw data from a form ie: pie chart?
When you create a survey is there a way to have the raw data from the form develop into a pie chart or tabulate such as “48% rate current uniforms as a 2 star” type of thing. Almost like Survey Monkey does? Is there a better way to export this data to view the responses from a survey? Thank you in advanced!!!
- How do i write a formula to calculate YTD totals of a given category
Here is the formula i started with. It gives me a #unparceable response =SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row), Date:Date, YEAR(@cell) = YEAR(TODAY())) Ive included a screen shot
- Workspace - adding a new sheet to a folder - report is not picking up that new sheet
I have a question about workspace and folders and reports. I have a company workspace with 3 folders in it; Active jobs, cancelled jobs and completed jobs. I have a report that pulls from the active jobs folders, but when I create a new sheet that report does not automatically pull in that new sheet. My question is, what…
- Addition of resources to Smartsheet
Greetings. The previous system admin of our Smartsheet account has left the organisation. How do we change the system admin now ? There is a need to add more resources to our account and we are not able to do the same. Kindly provide suggestions on what to do. Thank you
- Not able to set multi-select default values on a form?
Now that the multi-select field type is a new thing, it looks like when using that field type in a form, you're still only able to have the default value be one, single value?
- RANKAVG函数——细胞排除范围
Hello, I am trying to use the RANKAVG function but cannot figure out how to exclude a cell from the range selection. My equation is: =IFERROR(RANKAVG([Total Score]@row, [Total Score]$12:[Total Score]$77, 0), ""). I do not want to include cells [Total Score]24:[Total Score]26, [Total Score]39:[Total Score]41, [Total…
