Discussion List
Assistance with Formula for Faculty Course Counting
Hello, I’m working on a formula and could use some guidance. I have a list of faculty members who each teach multiple courses throughout the semester. My goal is to count each faculty member only once while summing the total value of the courses they teach—but ensuring that each course's value is counted only once per…
Personal Identification Information
Hi - I work in a K-12 environment where Google forms and sheets have been utilized for years. I am trying to transfer a few workflows to Smartsheet for better efficiency. The issue I am running into is PII. I need more than one data point to reference a student. My IT team does not think Smartsheet is secure enough -…
Bend-La Pine School District (K-12) Smartsheet user
Hello! I am Rachel Mavis, IT Project Manager. I have been using Smartsheet to streamline processes, to manage projects. I hope to connects with other people in K-12 to learn how they use Smartsheet.
Smartsheet for Financial Aid management, Alumni relations and course planning use cases
Hello Community, We are a team of consultants focused on building work management solutions for Higher Education. We are currently working with various universities on solutions pertaining to enhancing productivity, visibility and collaboration on use cases such as : Course Planning & Faculty allocation Financial Aid…
Higher Education
Hey! I am a lover of smartsheet but new to using it in higher education. Would love to connect with others in higher education. https://www.linkedin.com/in/rebeccaswilhelm/
Trying to count total points each specific person chosen
Howdy! I am trying to figure out how I can have a running total (Total Points) of the amount of "Points" each "Name" gets. Keep in mind, the same "Name" can be chosen multiple times. So, I would love for the total to be for that person in that row. 2 Weeks ago, they "Name" got 25 Points, today, the same "Name" received 10…
How do I fix a blue screen error (BSOD)?
How do I fix a blue screen error (BSOD)?
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",…
Update
I'm updating my profile.
Obtaining Student Plans
Hello, has anyone had success obtaining free student plans or any insights into how the process works? I work at a university and am trying to secure plans for graduate students supporting multi-site research projects. I briefly spoke with our university's account manager, who indicated that student plans are managed…
