-
Export Report Using Data Shuttle
I'm trying to setup an export of a report using Data Shuttle in Smartsheet (to export it to Google Sheets so that I can combine it with another of my reports) and when I type in the name of the report in Data Shuttle it finds the report but won't let me select it. If I click through the folders for the report I can't find…
-
Download Column Names & Column Types
We are making a master sheet to combine all of our 15 intake forms and sheets to help track metrics and more easily send intake rows/projects amongst teams once their portion of the project is complete and/or work on a project simultaneously. Is there a way to only view the columns for each sheet and their column…
-
How do you get a data shuttle filter to work on a column with a formula?
I'm trying to set up a data shuttle to filter out any studios that do not have "Send Survey?" checked. I've tried using "Send Survey? equals 1" and "Send Survey? equals True" and both don't work. Any help is appreciated!
-
Need 'Conversation' Widget for Dashboards
Typically, if a dashboard is displayed during meetings of any type, there is a need to capture a note or two regarding the content of the dashboard. It would be extremely valuable to have a widget where the conversation window could be included and notes taken directly on the dashboard. I have tried to add 'Notes' cells to…
-
Automation to allow Cell Change for Checkbox "Flag" or "Star"
Smartsheet TAM confirmed for me that we can't have an Automation change a cell value if the column type is a checkbox for the icons for either a Flag or Star. Can this be an enhancement request?
-
Projecting Project Burn Across Different Dates and Durations
I've looked at several examples but can't find something that helps me close enough with this item. I'm brining in budgets from another sheet, same with the Start, End and Duration for each task appropriately. I'd like to project the total burn for each month associated with the project, but only for the portion of the…
-
INDEX/MATCH works in one sheet, same formula gives #INVALID OPERATION in another
Hi all I have a Project Info section of my schedule sheet that I pull into columns so that the info can be used in automated emails about tasks. The sheet that's giving me problems is a copy of another sheet, where the formula works. =INDEX([Task Description]:[Task Description], MATCH("Portfolio", Task:Task, 0)) It works…
-
Card View Color
Smartsheet Community: When I switch to Card View, the Default Color is Light Blue for Every Card. Is heir a way I can Use Conditional Formatting to Automatically Color Code my Cards? At this time I only See an Option to manually change Each Individual Card.
-
Trying to gather cell info from 2 different unique id's on different sheets
The following sheets in my description are in 3 different workspaces if that makes a difference. We also do not have the licensing for control center if that is an easier solution, so im working with what Ive got. I have a sheet called "Project Intake" where most projects source from. There is an auto number column called…
-
Bridge Error: Failed to call add rows
I have a Bridge workflow that will add a row containing project title and some IDs. I added a new destination sheet to it, and I get the following error only for this particular sheet: The target column names and sheet ID are all correct, and I have editing rights to the sheet; I don't see any other issues. It works for…
