-
Item Changing with New Information Need Reporting Help
I have test for items a,b,c,d and a report that is pulling data from those tests. Occasionally I'll have an item that will turn to a version 2 now considered a2. Column information wont change. Now there will be an a, b, c, d, and a2 rows. What should I do to pull the correct information to my report now that a (the…
-
Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
-
Approval Requests - edit and delete like Update Requests
The Approval Request feature (Approval Requests | Smartsheet Learning Center) is lacking some of the functionality of the Update Request feature (Update Requests | Smartsheet Learning Center). I want to edit or delete an Approval Request that is pending on the row, the same way I can edit or delete a pending Update…
-
Override Ability on Max # of Columns to be Deleted at One Time.
As Excel doesn't have this limitation, neither should Smartsheet. Please allow a confirmation dialog to override. When importing from Excel, I'm left deleting five columns at a time for 5, 10, 15 minutes.
-
Text input field above the column names in grid view
I would like to see a text input field above the column names, similar to other spreadsheet software. I prefer using that over inputting directly into the cell, and it would allow me to work just a little more efficiently.
-
Two Sheets in One Report using same column
I have two sheets referenced in a report. Both sheets have column "A" which is a date column. Since Sheet #1 is the source, I would like to only pull column "A" from Sheet #1. Sheet #2 references(using formula to index match) Sheet #1's column "A" just for information. It seems when I use only Sheet #1 in the report, I can…
-
Is there a way to make a field in a form auto populate street address as its being entered?
I have a shipping management Smartsheet that has a intake form with a address field. When users fill in the address field sometimes they do not provide the entire address. I want the address to auto populate as they type in their address.
-
Is it possible to copy an automation workflow from one sheet to another sheet?
I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need to manually set up the workflow on my new sheet. Thanks!
-
Assigning people to tasks randomly and with a condition
Hello, I would like to randomly assign service representatives tasks, but only those who meet the criteria of already completing a task previously assigned to them. I would like to create a workflow or formula that would assign individuals on their availability and at random. Any suggestions?
-
Dashboards and Presentations
What are your best practices for using the dashboards for presentations to executive level? I am having difficulty displaying a dashboard within a PowerPoint presentation and screenshots are just not the best or most effective. Thank you!