Discussion List
Date formats
I have a date that is coming into my sheet via the CRM connect and the format is M/DD/YYYY. I need to create a formula that calculates 2 weeks prior to that date but cannot because Smartsheet does not recognize that as a correct date format.
How do I get the Move and/or Copy Automation to work properly?
This automation with work for a short period then stop and show me this error. Of course there is going to be a matching a matching column. How do I avoid it?
Making a Smartsheet Dashboard Public
I am working on a request to create a dashboard that can be viewed without logging in. I created the dashboard and set the access control to "Available to anyone with the link". However, it still requires users to log in using their Smartsheet credentials to view it. Is it possible that the System Administrator has…
Open to today's date... doesn't work
Even if the option is ticked, the gantt view opens always at the beginning date. It happens to me to all my colleagues, with and without licence. Please help
DataTable Error Notifications - Now Available!
Hi Community, I am excited to announce the release of DataTable error notifications! All users shared to a DataTable (admins and views) will now receive in-app and email notifications when errors have occurred. Error messages will state the error that has occurred and with what DataTable sheet Connection. Users will be…
Send Full Form with Description, Field Labels, and Help Text?
Good Morning, I am having a difficult time trying to find a solution for the following: I have built a Smartsheet and form to collect data from my clients. Many of the fields are pre-populated with data that does not need to change. This would include the client's contact information and other data points. I need to send…
How to create Auto notifications for particular row when Status changed to "Closed"
Issue with COUNTIFS
In row1 of my sheet I have helper text and thus want to exclude from any metrics I generate. I am currently assembling a sheet with the metrics i want and I have a hit a little snag; my formula is counting the data in row 1. I have: =COUNTIFS({Surveys and Works - Task ID}, <>"D1", {Surveys and Works - due date}, <=TODAY())…
DYNAMIC VIEW header instructions.
The dynamic view is a great way to share information and collect information from a wide audience without " sharing" each individual or group to a sheet or report. By definition, the users I share information with are casual users of Smartsheet, or this Dynamic view may be their only interaction. It would be great if we…
MAX and AVG query
Hi, this is linked to a another thread and I am struggling. Row 1 of my main sheet contains helper fields. On a separate sheet I am developing metrics. I want the metrics to exclude row 1 in its calculations as it's skewing the data. Row 1 contains a Task called D1 - see screenshot. My metric code is =MAX({Surveys and…