-
Remove Primary Column From Report
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
-
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…
-
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…
-
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…
-
How to highlight the values in the column which is greater than or less than the other column values
Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?
-
Count formulae
Hi all, Need a bit of help with constructing a formulae to input into a sheet summary box for the below situations: To calculate the count of 'Medical Device Related' category from the 'Relevant System' column Same as the above but for 'Non-Medical Related' category I want to have a breakdown of the sub-categories for each…
-
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…
-
Which learning path should I use for certification?
Good morning, I am aiming to take my certification exam for work but am unsure if I should go with the eLearning Self Paced Course or the Core App Instructor Lead Course. Some posts suggest one way and some suggest another. What should I do?
-
Is anyone else having trouble with the videos in the Self-Paced Core App Learning Path?
I'm currently taking the Self-Paced Core App Learning Path via the Smartsheet University website. Most of the videos have been working fine, but every once in a while there will be odd issues. For example, I was just doing an exercise on the COUNT(CHILDREN()) function where it was about to show how to apply the formula to…
-
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…