-
Creating a dashboard chart to represent the star symbol feature
Hello! We use the star symbols as a column in our project schedule to show the status of the project. I need to create a chart that shows graphically these statuses but have been running into many issues. To help, I created a column in the schedule that is automatically populated with the number of stars for that row.…
-
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…
-
Column Finder
Provide a better way to find a column in sheet. For sheets with many columns, it is sometimes difficult to locate the column that you are looking for. It would be better if there were a dropdown that listed all columns in alphabetical order so that selecting it takes the focus to that column.
-
Form dropdown options pulled from another sheet
Hi! I would like to make a form with the options pulled from another sheet. This is to prevent an incorrect project code being entered. The column drop-down options would need to be a the list of project codes from another sheet. The drop-down options would need to update continually as new project codes are added to the…
-
Find the position of an element in a dropdown list
I have two columns: Column One: It's a multi-select dropdown list with the names of products (the quantity of selected products can be very long) Column Two: It has the quantities of each product in the same order as Column One, separated by commas. Example of one row: Column One (dropdown list with multiple choices):…
-
Customizable view options in Smartsheet Card View
I think it would be useful to be able to customize the Card view in Smartsheet grids and reports to include additional view options, such as by date or other custom columns, instead of being limited to the default options like "status", "schedule health", or only being able to view by columns that are dropdowns or symbols.…
-
Check A Box When A Value On Another Sheet Changes
I have a sheet that is pulling data from a second sheet. What I want to happen is when the status changes to RECEIVING COMPLETE on the second sheet, it checks the box in the received into stock column. The problem is that once that status is updated to that value on the second sheet, it's moved onto an archive sheet that…
-
Workspaces taking up a section of my screen
Hi Smartsheet, Why does Workspaces take up a section of my screen? I'm not able to scroll all the way wide right when the Workspace panel is open. Thanks, Eric
-
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!
-
Problems using Python API and Cell History - note returning all user input.
I have been using the cell history to try and grab user input. The Input comes from users typing or selecting from a drop down. The data shows fine in Smartsheets. Dates are auto added but text e.g. "11k Production process complete" is user input when using the report/sheet in Smartsheets. But then when I use this code to…