-
Countif and HAS for multiselect for Quiz answers
I am using Countif and HAS to count a cell if a person has selected the correct quiz answers in a multiselect field. =COUNTIF([Q2]@row, HAS("a", "b", "c", "e")) This is returning 0 and I am not sure why?
-
Sort in sheets
Good afternoon, Oh, how I long for sorts within a Sheet to be saved like it is in reports!! We have a set sort we need, but it gets undone throughout the day by other users. When will this be implemented to save the time of having to constantly resort? Also, having more than three sort options for a sheet would be beyond…
-
Way to automate check boxes in a form?
Hello, I have a form with multiple check boxes for people to check off based on which option they want (they can select multiple or just one). I want to be able to have an ALL OF THE ABOVE option but want to find a way so that when a user of the form checks ALL OF THE ABOVE, it will automatically generate all the other…
-
Move Attachments Only sheets to sheets
From reading other posts I don't think this is possible.... is there a way to copy only the attachment from one sheet to another? I do not want to copy rows. Enhancement request for this function please!
-
Using HAS() with contact and multi contact columns
What formatting do I need to use in order to search inside a cell for a contact? I keep getting #IMPARSABLE
-
Creating a Rule to Automically Hide Rows
Is it possible to create a Rule, Conditional Formatting, or Workflow where when you check off a Box on the sheet it then hides that row? If not, can I request this feature from SmartSheet? Thank you
-
Multiple nesting help!
So I have 6 survey questions with response options of "below expectations, meets expectations, and exceeds expectations." I need it to tell me how many below expectations for question 1 are in each region and so forth for each response option and region. So far this formula works great! =COUNTIFS([Delivery…
-
Creating a Milestone Sheet (referencing project plan)
Hi All, I have created a project plan in Smartsheets and am tracking milestones using tags How do I create a separate sheet which only shows me milestones, its start/finish (i.e start=earliest start date with a particular tag, and end=latest end date with a particular tag), its % completion (based on the milestone tag) and…
-
Case sensitive COUNTIF
I'm trying to mark duplicates in a particular column per the discussion here: https://community.smartsheet.com/discussion/comment/319478#Comment_319478 My issue is, the column I'm checking has a mix of uppercase and lowercase letters that define unique IDs, and COUNTIF unfortunately, is case insensitive, so it is marking…
-
Help With Index Match (#Invalid value)
I am trying to return a Contact value Cell from a lookup table, in the Column "Assigned Contact Email" according to "Week * + Day*" and "Shift Assigned To" in that Row This is what I want it to look like. ^ This is the other sheet with the look up table. ^ This is the Formula I have used. ^ ^ For the formula, Red is the…