-
Logic for Required Fields on Forms
I have a form that I am working on where I would like this logic: If box is checked, then field is required I spoke with support and they informed me that this is not a currently available feature. What I'm trying to do on my form is have it so if the user checks a box that they want someone to reach out to them, then they…
-
Display all series in the legend for Pie & Donut Charts even when the value is 0
Currently the legends for Pie & Donut Charts will not display a series in the legend if the value is 0. All other chart types do, but Pie & Donut do not for some reason. This is really frustrating when creating dashboards, because if/when the value updates to a non-zero amount the series colors get all wonky & you have to…
-
Any Fix Coming for the Long-Standing Time/Date Issues? (Time Zone/Server Time/Local Time/GMT)
I ran into another case of time discrepancy causing date value problems, and it's getting frustrating that this hasn't been addressed yet. I know there are workarounds for this, but it seems like something so basic should have been fixed long ago. In this case, I have training class attendees who use a form to sign into…
-
Add a Button To Collapse Or Expand a Grouped Report in a Dashboard
It would be nice if we could have it both ways on a dashboard. It can be frustrating that you can't collapse a grouped report if the person that set it up set it up expanded and vice versa. There could be a button somewhere on the report that collapses all or expands all.
-
Capability to associate user's manager & to create easier reports
Associate a user's manager with each user at their account level and enable similar functionality to "Current User" whereby a manager can filter by contact columns where they are associated with the contacts. Manager needs to be able to quickly filter content in sheets and reports to resources (contacts) who report to the…
-
MAXIF, MINIF, AVGIF Formula Capability
It would help to have the IFS functionality and combined statistical functionality MAXIF, MINIF, AVGIF, MAXIFS, MINIFS, AVGIFS similar to the current SUMIF and COUNTIF. IFS can shorten multiple nested IF statements and easier to formulate, read and understand when referencing multiple conditions. The combined statistical…
-
Schedule Data Shuttle for a Specific Day of the Month
Unless I am missing something, it appears that you are unable to schedule data shuttle on a specific day of the month. I have a monthly report that comes on the 10th that needs to import into Smartsheet. It appears the only way I can make sure data shuttle catches this is to run it every single day forever. There is a lot…
-
Preserve original formatting in automated alerts
Dear Smartsheet team, I found that the automatically generated table by Smartsheet and incorporated to email (generated as a part of Alert someone automation workflow) for some reason lost the formatting of cell, f.i. if on the original Smartsheet webpage the cell is colored in green and text is bold in email I see regular…
-
Send an email update to a row without direct email integration
Many project management and CRM tools I've used provide an email address for each project in order to use it to forward an email update directly to the row (or use the CC with this email so the email record goes directly into the row comments/conversation). Smartsheets should offer the ability to view the address (for…
-
Word Download from Document Builder
Hello Smartsheet Team, A suggestion for functionality to external users of SS! In the Document Builder, 'Generate Documents' process, it would be helpful to allow for downloads other than the pdf out, such as MS Word docx. Providing my team with the ability to download a document, after it has been set up with fillable…