-
GLITCH? Text isn't wrapping nor doing a copy/paste correctly
Good morning, I've discovered that text is no longer behaving well within the cell. I'm see words cut off within the cell, whether or not the cell is formatted to wrap the text. Thus, it makes copying the text and pasting it wonky. I often have to copy/paste text from SS into Word. It pastes with embedded formatting that I…
-
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”,…
-
Hide Email Address on Webform using Contact List
I am trying to find a way on the Smartsheet web form to display the Name from the contact list, but not the email address. This is a public form, and while I want to be able to alert the event coordinator that something has been submitted, I do not want to publish the email address along with it. Thank you