-
Allow Parent Row Update Request to Include Children Rows
The idea: When creating an Update Request for a parent row, allow the selection and inclusion of Children rows. When creating an Update Request, you can specify which columns you want to include in the request. I recently encountered a situation where I wanted a user to update a section of rows (Parent + 5-6 Children). In…
-
Integrating custom HTML or JavaScript into the smartsheet dashboard.
I wanted to embed a file/URL of a custom HTML code made in order to have a dropdown menu in the dashboard and make it easier to organize data. I think it would be a great idea to be able to integrate custom HTML and JavaScript into the dashboard! Another idea is adding a feature to create a dropdown menu for convenience…
-
new GRANDPARENT() function
I would greatly appreciate a Grandparent function, especially since PARENT(PARENT()) throws an error. I know we have ANCESTORS(), but that gives you the number of ancestors and I need the specific ancestor value. Ideally, the GRANDPARENT() function would be GRANDPARENT( [reference], [# of generations back] ), that way it…
-
PI formula
I need to reference PI for circle maths. a PI() function or a universal variable would be very useful and I'm frankly shocked it doesn't exist already. It'd function exactly like TODAY() but a number instead of a date.
-
Column border style
Hello! Just a simple idea that might be interesting for other users. When you have many columns with different categories, there is no simple way to make a visual distinction that allows you to "group" data vertically. So far, what I'm doing is to create a "fake" border using an empty column with background color. This has…
-
Renaming Column Name in Report
1) Is it possible to change the Name of Column in Report instead of Source Sheet. 2) Auto Columns name is appearing in the Report instead of Column Name (Ex. Created by , Modified By, Created Date and Modified Date). Is there any way to change System Columns name in the Report. Thanks for your support. Best regards.
-
Checklist Report
Hello, In my smartsheet, I have something of a checklist with all checklist items on a new row. Each item is accompanied by about 5+ columns for "Checklist Item" "Complete?" "Due Date" "Close Date" "Notes" and so on. The checklist is to be duplicated for each new program we launch and contains 124 checklist items. Since we…
-
Folders for Automations
I have many sheets that have a TON of Automations that I have built. I would like to see folders for automations be added where you can group your automations that work together into folders for easy navigation when editing. Currently, I have to scroll an endless list of automations to find the one that I am attempting to…
-
Better automation design: visual queues
I have a love/hate relationship with Smartsheet automation. On one hand, the automation has saved me countless hours of work. On the other hand, the way the Automation for a sheet pops out and covers up the data is maddening! Having the automation pop up in a separate, re-sizeable window would be awesome. Taking it a step…
-
Improved integration with SQL
Hi! I have some grumpy developers with a HUGE ask, likely impossible, but at the very least difficult. If it is easy then roll it out! Have better cel controls where only Text is allowed, or only a real Number, or only an Advanced Number. These are things that MS-Excel cannot do, and if Smartsheet can do there would be…
