I've been playing around with this all day. I'm trying to figure a way to compile a list all the unique values in a given column (in this case, business entities/customers). I'm matching that against …
Hello All, I was wondering if anyone has found a way to have a link/button in a subsection of their project plan (for multiple different lines in the plan) where they can click and bring up a blank me…
Hello, I am trying to generate a chart from a report that contains three columns. The first is the subject (label), the second the day (time to be plotted on the x axis) and the quantity (to be plotte…
I have 2 things I am trying to resolve. I have about 100 external partners who need to see current status of a submission. so Far i am able to display that info in Dynamic View. But I can seem to get …
Good morning, I have date columns created for the 5 milestone dates that each task/row can be assigned. Is there anyway to get all Milestone dates (date columns) to display in the calendar view. I hav…
Hi there! I have been using the new functionality of the "Drop-down Multi-select" column and I am trying to capture all of the different combinations that can be selected within the column. The column…
Hello, I am new to smartsheets and use it for work here, in the healthcare field. I am trying to figure out the best way to utilize smartsheets to track productivity for a multisite clinical trial. I …
Good afternoon, I am trying to return values in a cell based on data in another cell as it falls between a range Here is the range: 1 Star 299 - 966 2 Star 967 - 1160 3 Star 1161 - 1330 4 Star 1331 - …
Hello, I am creating a metrics sheet that cross references an archive sheet and am looking to pull statistics within monthly ranges. I want to return a monthly average of the Total ADL Score within a …
Hello, I am trying to create a monthly trend report. The report function is not specific enough for what I need, so in order to do this, I have created a metrics sheet that references 21 different ori…