-
Combine columns in the report
I would like to have an option to combine two columns together into one ie. status and request status. That will be useful for cases where we are unable to change column names in the source sheets.
-
Add Latest Comment Column without creating a comment
When creating a Grid, need the ability to add Latest Comment in Grid view without having to add a comment first. Thank you.
-
auto lock Summary Fields
Hi I'd like a way through automation to be able to lock summary fields based on criteria in a sheet cell, or another summary fields. I use Summary fields as a switch to do actions in sheet. for example I allow PMs baseline effort and costs through changing a summary field trigger to yes, but after they have done that I…
-
Generate cross sheet reference names using formulas
Instead of manually typing the reference name, it would be extremely useful if it could be allowed to generate the string into the curved brackets using a formula. In the same way it would useful also using Summary sheet fields in it. Example: =INDEX(COLLECT({Sheet1_Name}, {Status}, "Enrolled"), 1) could be…
-
Click on Conversation Comments - direct to row
The ability to open conversation comments in right hand of a sheet, then click on the row number (under unread) and instead of marking the message read, go to row, separate click on row and mak read as two different functions.
-
View options of Reports in mobile devices
Hi On a mobile device, the view options of Smartsheet Reports should be the same as those given in the view options given in the Sheets. Viewing the Reports at present is very inconvenient, in the absence of these View options (found in the Sheets). Please see the screenshots below for reference. Report View options (on a…
-
User Defined Fields for SysAdmins
Hi all, Our Enterprise user base has expanded globally. I am often asked how many users are from xx country or provide all users outside of NorAm. We capture this when users request the product but it would be much easier if this could be a field available when the user is provisioned. We would also be able to setup a…
-
Pivot Table Like UI For Creating Metrics in Sheet Summaries
In Excel you can customize formulas and drag and drop the information you want int Rows, Columns, Filters, etc... via Pivot Tables to build data points and summaries of large amonts of data. If we could bring this functionality to Smartsheet's Sheet Summary with the help of the recent LLM functionalities implemented for…
-
Connection with Onit via Data Connector
I'd like to connect Smartsheet with Onit via Data Connector. This would eliminate manual work and human error and would be much more efficient to the current process (downloading excel spreadsheets from Onit and creating worksheets in Smartsheet, to track progress and include all details on the dashboard). Thanks!
-
Joint Report (like joint query)
If I have a project and roles in each project. So, if I have a project details sheet, and project ID to role details sheet. Each project many have many rows in the role details sheet. Can we have a way so we can merge the two sheets in the reports so each row displays the columns based on where that column is coming from…
