Discussion List
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…
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…