Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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))
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
