-
Automatic WBS Numbering
We have a work around but it takes multiple helper columns and complex formulas. You need WBS numbering 1 1.1 1.1.1
-
Image import from Excel/Sheets
When importing a spreadsheet from Excel or from Google Sheets, it would be SO helpful to have embedded/pasted images come into the new smartsheet as attached images. Use example: Users copy/paste screenshots into a Google Sheet being used as a bug tracker, because Google Sheets makes it very easy to do, but then they're…
-
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.
-
Include predecessor references with copy to another sheet
Sorry if this is already in the forum. I searched and did not see it submitted as an idea. It only comes up in other discussions. Issue: When using copy to another sheet, the rows do not maintain their predecessor references. Use Case: We utilize Control Center to provision our projects from a standard "PROJECT TEMPLATE".…
-
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…
