-
Higher Ed - Grants management
Hello all, I work for a university and I have to track the grants! I need to track dealines of reports, Invoices submission, payments and grants close out. Does anyone has a template they would like to share? Also, does anyone uses Smartsheet to communicate wit PI the balances on their accounts? Thank you, Jacqueline Morana
-
CONTAINS to count cells with specific string of numbers
Is there a way to use COUNTIFS and CONTAINS to count cells that include a specific string of numbers as well as cells that include that string plus something else? In the example below, I'm trying to count the number of students who are taking the course with the Code "20659," which should include those taking only that…
-
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…
-
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 🤩
-
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…
