Sign in to join the conversation:
I am trying to count the number of times a specific schedule date is listed in a column for a sheet, not able to narrow down the formula exactly
I tried the following with no luck - =COUNTIFS({MEDCTR-1 Range 1}, "12/02/19"). All I get back is a value of 0 even though I have 64 cells that meet that criteria
When referencing dates in a formula, you need to use the DATE function.
=DATE(yyyy, mm, dd)
=COUNTIFS({MEDCTR-1 Range 1}, @cell = DATE(2019, 12, 02))
I have a form that will be filled out internally. There's a cell labeled "Department" which contains 8 dropdown list values. There's a another cell called "Executives" which are the leaders of these departments. In the form, I'm attempting to do a logic where when you choose a specific "Department", then the cell…
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…
what i can do if all my existing smartsheet gant files can't be open after change my plan to Pro? what could be the reason ?
