-
Formula to count cells in a column if box is checked
I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box. In other words, there are two columns to include in the count from my Communication Tracker sheet: Done -- checkbox column and Department -- dropdown column with…
-
Drop-down list
I have a drop-down list of names on my sheet. I need to remove one of the names and add a new name, but I want to keep the list in alphabetical order. I can't find a way to re-order the names in the dialog box where I add the new name. Does this mean I have to go back, delete all, and then re-enter the names, placing the…
-
Count a Titled Course if there is text in the cell, but not "OTHER"
Sometimes more than 1 course is taught at the same location. I am being asked to count the number of courses taught, quarterly. On rare occasions, a course is not taught and OTHER is entered in that column. (OTHER could mean initial meetings, graduation, etc.) Here is the existing formula. =IF([COURSE 2]@row = "OTHER", 0,…
-
I need the sum of random cells in a row
Here is my formula, and S/S does not like it. = [National Instructor 1 Numerator]@row + [National Instructor 2 Numerator]@row + [National Instructor 3 Numerator]@row + [National Instructor 4 Numerator]@row Am I missing something? I copied this from another community question and she wrote back that it worked, but it's not…
-
Graphing Data
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from a dropdown list), time of day (from a dropdown list), their location (from a dropdown…
-
Tick a checkbox depending on value of another field
I have a multi column Smartsheet that tracks items by date. Part of the functionality shows the number of days the item has been active:- =IF(OR([S.Status]5 = 3, [S.Status]5 = 1), TODAY(0) - [Start Date]5) There is also a check box column. What I would like to do is to automatically tick the check box if the number of days…
-
Added information needed on Approval workflow
I have many forms - which are requests that need approval. When I create the approval workflow, it sends 2 buttons - Approve or Decline. I need more. I need a NOTES section for when it is denied so that the reason can be recorded on my sheet. I also need the name and date of the approval added to my sheet. The only thing I…
-
Help with IF(AND) formulas
= IF[Instructor 1 Last Name]@row = "" - AND [Instructor Status]@row = "U.S. Instructor" - I need it to count as 1. Otherwise, 0. What I've written above is what I want to do. Below is the formula, which gives me the dreaded #UNPARSEABLE. =IF(AND([INSTRUCTOR 1 LAST NAME]@row=””, [INSTRUCTOR 1 STATUS]@row=”U.S. Instructor”,…
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
How to resubscribe on an automated workflow
One of the users mistakenly unsubscribed from the workflow email notification, how can they be subscribed again to this particular workflow?