-
Allow Count Unique Values Only In Report Column Summary
In addition to being able to count and sum a column in a report, I'd like Smartsheet to be able to count UNIQUE values within a group. For example, I have a report shows me all tasks from multiple projects and groups by project manager. If I try to count the Project column to see how many projects each Project Manager has…
-
Validation Phone prefix countries missing
When adding a Field in a Form and adding a Validation Phone, there are several missing countries: Croatia, Indonesia, Mauritius, Morocco, Nigeria, Philippines, Serbia, Taiwan, Thailand, Turkey, Vietnam, Uruguay and others. Would it be possible to check and update?
-
Line Breaks in Text Fields on Forms
We would like to be able to use line breaks in the text fields of forms. For example, if you are typing data into a form linked to a smartsheet, it would be helpful to have the capability to skip lines or "enter" to the next line to continue inputting information. This would be helpful in both data organization and…
-
extend the timeout period for calculating formulas/saving sheets and reports
Currently, when a sheet / report has lot of formulas (but under the max limits quoted), it will take time to save the file. There is a timeout set in the system that the save will fail if the timer expires. Advised by support team, need a feature request to extend the timeout. Workaround now is to reduce the number of…
-
Printing embedded sheet within dashboard minimised
When embedding a sheet within a dashboard, this appears normal and stretched across the page. However, when printing the dashboard which we do from time to time to include in board papers, the embedded item becomes minimised. Currently there is no work around other than printing it as an individual sheet and having it as…
-
Scroll through attachment images
It would be great to scroll through attachments without having to open each one individually. Thanks
-
Dynamic View: Show Dates in the local timezone (not in UTC)
When a datetime field is shown in a Dynamic View, it's always shown in UTC ISO-8601 format, that is, YYYY-MM-DDTHH:MM:SSZ. UTC date time format is not useful for end users, so it should be changed so that it shows in the local user's timezone instead.
-
Conditional formatting OR option
Please create an OR option for conditional formatting. I have a list of 50 numbers, and I need to highlight if any of them exist in a specific cell. Without an OR option, I have to make 50 rules to accomplish this. Frustrating!
-
Cell linking and the addition of new rows in master
Please configure cell linking to reflect the addition of rows in the master to the linked sheet. We are constantly adding new rows of data to our sheets and would love if those were reflected in the subsequent sheets. Hard to believe this is not already implemented into your system...
-
COLLECTMOD() formula
=COLLECTMOD([Return Range],"Modify Return Range",[Range 1],"Modify Range 1", "Range 1 Criteria", ...) Leave blank if there is no modification to the range.
