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)))
I am creating a form which I want to include a link to a PDF file for anyone completing the form to reference. The PDF is attached to the sheet which the form is associated with. How can I make that PDF accessible to someone completing the form? The closest thing I've found is to create a URL link to the PDF, but that will…
Hi everyone, I accidentally removed the Admin (Owner/Admin access) from one of our Smartsheet sheets, and we're no longer able to manage it as intended. Is it possible to request a backup or restoration of the sheet from Smartsheet Support? If so: Can Smartsheet restore a previous version of the sheet? What information is…
Hello everyone seeking for an answer and help please im having a hard time on approval request automation . My workflow runs smoothly however when the approver open the attachment on the request it automatically downloads and when clicking the approve it says link are already used and auto decline teh approval request…
