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
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 re…
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 d…
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 o…
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 l…
Hello, I have a table of data that looks like this: I am needing to create a formula that will count all of the "1" in each column, that do not contain "OPEN" in the name field. So far I have created …
I want to count how many columns have a date in the "SMD/IME Appointment Date" row and where the "Case Closure Date" cell in that column is blank: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]…
I am working on a marketing project plan template, and some of our campaigns spend multiple days in market. Tracking the performance of these projects happens for the duration of the project plus the …
Hello, I am currently trying to get a sum from two values. One of the values is from the most recent Sunday, and the other is the Sunday prior to the most recent one. I need to find the difference of …
