-
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?
-
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…
-
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…
-
How do I make my Smartsheet columns update when I update the Form
I'm brand new to Smartsheet Forms and I'm on deadline. I accidentally created a Form tied to the wrong Sheet. After realizing my mistake, I duplicated the original sheet and fixed the new column headers (which had populated when I created the Form, of course!) and went back to the original incorrect Sheet ... I THINK it's…
-
Smartsheet University Access Point is moving...
Hi Community, Just a quick update today that we have moved the Smartsheet University Access point into the help menu. The hope is that in making this change it will be easier and more intuitive to find Smartsheet University. This change is across all plans with Smartsheet University access Once a Smartsheet University user…
-
Is there any way to select only specific columns to be included in alert messages that are sent out
Is there any way to select only specific columns to be included in alert messages that are sent out using the SmartSheet Automation feature? Currently, I set up an alert. And it displays all of the columns, even if I hide certain columns in the sheet. I'd like to be able to select which columns are sent and included as…
