-
Leave automation conditions in when workflows break
I recently got the "Workflow has been deactivated" email on a sheet that I inherited in a large workspace from a former team member. However, when I went in to troubleshoot the error, I was unable to because the name of the sheet it referenced was gone, replaced by "unknown sheet". It would be much more helpful if we could…
-
Include Sheet Summary fields in Row Reports
I've seen several queries about this, and workarounds but can't find a suggestion so here's one! I have multiple sheets with the same name (in different workspaces). I want to use a Row Report but separate out / summarise the entries per sheet. The only field I can use is "sheet name" which is the same for all, but what I…
-
Function "Current User"
Of course, the information about the current user is already available in the system, after all we can access it via filter. But I miss a function that would allow identifying "Currentuser()" via formula. I'm making individual dashboards and would like to generate personalized statistics for each user, which are…
-
Current User System Field
System Field that captures who the current user is so you can use formulas or logic based on that.
-
Notification when Tagging Non Permissioned User with Dynamic View
We are leveraging Smartsheet with user groups who do not have permissions to the original sheet, but have access to comment through dynamic view. While tagging users who do have access to dynamic view, we are still getting the attached notification causing a lot of confusion for our internal users. It would be of great…
-
Formula Entry Formatting
I'd like to suggest an enhancement for the formula bar in Smartsheet. As it stands, users are unable to expand the formula bar or input/format multi-line formulas directly. This limitation is particularly challenging when dealing with complex formulas, where keeping track of parenthesis pairings and overall structure is…
-
IDEA: Slightly Offset Formula bar while editing so that you can see or click on referenced cells
I can't be the only person that is VERY bothered by having the formula editing bar in the SAME row as the row you're applying it to? It drives me nuts when I try to type in a formula and the editing window COMPLETELY COVERS the entire row, so I cannot see the columns/cells that the formula is referencing, nor can I click…
-
Send Dashboard via email - manually and automated workflow
My idea is to create functionality to be able to send a dashboard snapshot via email from within Smartsheet, both manually and via an automated workflow. Ideally using an HTML format so any links in the dashboard are links in the email. Smartsheet Dashboards are fantastic and we use them heavily with our project teams and…
-
Numbers only column
There should be an option to make a column numbers only. I've had trouble with sum functions, only to find that people have made 'non-numeric' entries in fields that are intended only for dollar amounts. When this happens, I have to go in and find all the non-numeric entries and delete them to get the sum function to work.…
-
New column type: Currency-only
I see there’s already an idea requesting a "Number only" column type, and I’d like to suggest adding a "Currency only" column type as well. Currently, I have to create several workarounds to validate certain fields we collect. For example: Ticket number or Purchase Order number fields should only allow numbers and have a…