-
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 Function - exclude cell from range
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…
-
RYG Ball Automation
Hello, I am trying to automate RYG ball based on Y/N responses to other cells OR I could change the Y/N to also be RYG if that would make this possible. Essentially, my overall goal is to automate the RYG ball based on how 26 other fields are answered -- 13 or less are green = Red 14-19 Green = Yellow 20-26 Green = Green…
