-
Efficient Monthly Report Data Collection System for Faculty using Smartsheet
I am looking to create a streamlined system in Smartsheet to collect monthly report data from faculty members efficiently. This would include updates on publications, grants submission, presentations, etc. The main goals include consolidating all of this information in one place, providing a user-friendly interface for…
-
For profit education space - any others out there?
Hi there - I work for a for-profit company that runs schools, delivering classes and programs in various industries. This puts me in an interesting cross-section of education. Wondering if there are any others out there in a similar situation and how you've found Smartsheet to be most useful in some of your most common…
-
FINALLY!! There is a Smartsheet **Education** Community
I just happened to stumble upon this, and I'm delighted to see the Smartsheet expansion within the field of education. I've been utilizing Smartsheet for 13-14 years to create data collaboration solutions across every department within the school framework. While I have, specifically, served only virtual schools during…
-
Higher Education projects and dashboards
We partner with institutions to deploy Workday, and use Smartsheet for all of our project oversight and tracking. We use it for everything from project planning, testing, RAID log, calendar, etc. I would love to see how you are providing transparency for your projects, and think about how we can stretch what we do even…
-
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…
-
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…
