-
Educational Publications
Hey Everyone, My name is Brandon Good and I work at ETS where we develope assessments and publications for education. My group has been using smartsheet for four years now to manage and track the production of all our products we deliver to our clients. We are currently looking into how to utilize Data Shuttle and the…
-
Team Awesome!
Hello! My name is Maia Maclin. I work for the illustrious Morgan State University, in the Office of the Registrar. We have been using Smartsheet since 2021. It has dramatically changed processes at our university. I am open to collaboration and sharing information and best practices. Check out our presentation at AACRAO…
-
Template for Tracking Admissions Data
Hello SmartSheet! I am trying to decide which template to utilize for my admissions data needs. There will be 200-300 students total, and I need to assign them between 5 reviewers. They need to be able to score the student 1-4, leave comments, and mark when their evaluation is complete. How might I organize all this data…
-
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…
-
Moved: Formula to count of items in a multi dropdown list
This discussion has been moved.
-
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 🤩
