-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
Pre-Filled Criteria and Automatic Alerts
Just looking for some clarification regarding triggering workflows. We've recently been attempting to use SmartSheet to notify university employees about their work assignments for commencement. Because we wanted a fast way to collect data that we could pre-load into SmartSheet, we used another platform, created an excel…
-
Flagging a Date and Time Overlap
Hello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as many as 6 to 8 classes in a day, but only have 4 conference lines. I'm trying to write…
-
Limiting responses in Smartsheet forms?
Working in education here and I'm part of a team attempting to schedule volunteer positions for an event that staff must mandatorily be part of. We have a list of positions that need filled, and Smartsheet is going to be great for managing the workflow once they are assigned... However, in Smartsheet forms, I can't find a…
-
Smartsheet for Curriculum Planning & Execution
Hello Friends, Have any of you used Smartsheet for curriculum planning in public education or employee training? I am in the process of building a 4 year high school business and technology program and am considering using Smartsheet, or something similar, to develop a plan. Thanks and feel free to share if you have some…
-
Greetings from NC State University - Raleigh, North Carolina
Hello, I am Alicia Lecceardone Fraccaroli. I work in the field of human resources in higher education at a public land grant university. I just started using smart sheets within the last few months and I am already smitten 🤩
-
Combining IF(AND and IF(OR statements
Hi all, I am trying to build a combined IF statement for a date validation field. Both of these statements work on their own. The first statement returns "University Holiday" if the "Preferred Date" is a holiday... =IF(OR([Preferred Date*]1 = "09/02/19", [Preferred Date*]1 = "11/28/19", [Preferred Date*]1 = "11/29/19",…
-
Dashboard chart values too large
I've created a dashboard for our campus to show how much of our Fall schedule will be taught in person vs online. The total of all the data is 100%, yet the stacked bar chart goes to 120%. Fortunately, the legend is light and hard to see, but still, we are a university, so I should be able to do an accurate chart. I'm…
-
Classroom Assignment
Hello, does anyone have or know of a solution for automatically assigning classroom space ? I have to build a sheet for the automatic assignment of classroom space referencing the registered number of students from another sheet, and keeping in mind the classroom space time availability so as not to overlap courses in the…