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 have a field - Let's say Closed Date
I am wanting a count of only those with close dates between 9/1/19 and 9/30/19. I keep trying different formulas but i keep getting the unparseable error
Try something like this...
=COUNTIFS([Closed Date]:[Closed Date], AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2019))
This will give you the count of all dates that fall within the month of September in 2019.
.
If you need to be able to specify the dates, you can try something like this...
=COUNTIFS([Closed Date]:[Closed Date], AND(@cell >= DATE(2019, 09, 01), @cell <= DATE(2019, 09, 30)))
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…
