-
Add more than one column data to chart (x,y scatter)
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 plotted on the y-axis). Since I am plotting from a report, I don't want to reformat the x data to columns as other posts have…
-
CALENDAR APP/Dashboard current user view
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 the Calander App and Dashboard Widget to show graph. without sharing them to the source sheet.
-
Displaying multiple "dates" in calendar view from same row
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 have set up color codes to help determine which is which but now I can't figure out how to get them all to display, looks like…
-
Formulas with Drop-down Multi-Select Column
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 is supposed to capture the root cause of an issue and the person working on the issue is able to select multiple root…
-
Multisite Clinical Research
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 have found some articles describing how you can use other products along with smartsheets to track just single site clinical…
-
Combined IF AND formula with range
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 - 1509 5 Star 1510 - 2300 I've gotten through 1 Star and 2 Star but am receiving an error when I try to tack on the next range…
-
AVERAGEIF value between a date range
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 monthly range which is determined by the ARD (Due) Date column. This data is returned to my metrics sheet (Sheet name: Avon…
-
COUNTIFs formula with Date Range
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 originating sheets. To fill my metrics sheet, I need to use a COUNTIFS formula to reference a date range. I've tried it a few…
-
Census Information for a company
Is there a way to add and delete employee info with an automation and formula. I need to get accurate count of how many people are in the company and what tier they fall into. I would like to have an up-to-date sheet. Updated Census Sheet
-
Send alert to task's assignee when predecessor task's status changes to complete
Hi all. New, enthusiastic user here hoping for some guidance. In setting up a repeating process, I have dependencies/predecessors clearly identified. Wonderful! Now, how does one set an alert/notification to auto-send to a task's assignee when the task's predecessor's status changes to "Complete"?
