DataTable Run Errors
I'm trying to pull from a DataTable, but I keep getting this error message: I've tried to delete and rebuild the connection, but I'm not having any luck. Is it some type of server error, or is it another type of issue?
Connect Smartsheet with MS Excel
Hi, Would any of you be able to point me in the direction of a video or simple explanation for how to draw in live cell data from a Microsoft Excel spreadsheet that is housed in MS Teams, please? I'd like to be able to take a revenue cell from an Excel sheet that is in a Teams folder (and is updated by a team that doesn't…
Unable to enter user comments in dynamic views with a filter
I've encountered an issue while implementing a feature in a dynamic view with both a filter and user comments enabled. Here's the problem: the view permits users to make updates to the record in the 'data' tab, but it forces them to 'save' it before transitioning to the 'comments' tab. The challenge is that, due to this…
Fill Form in Google Doc and populate sheet
I saw that it's possible to populate a form using the values on smartsheet, but can it be done the other way? to fill the google doc and populate the values in the sheet?
Dynamic view and Automation
Forgive me if this has been asked/answered before, but I cannot find anything helpful and Support was not at all helpful. Can I use Dynamic Views in combination with conditional logic in Automations? For example, is a user has a dynamic view that shows 20 rows of data, but there is an automation that I want to run…
Why is Dynamic View allowing me to build logic based off one set of dropdown values but not another?
I have a Dynamic View built from a report of multiple sheets. I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here: But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values…
Smartsheet tabs in MS Teams
I've read the help articles, etc. and tried some things but I'd like to get the communities feedback on this. So to put a sheet as a tab in a Teams Channel you can either publish it and add a website tab for it or you can add the sheet directly from the tab as a Smartsheet app. Seems the biggest factor there is…
How can I use logic with a hidden field?
I have a dropdown field named "Survey Type". I have 1 survey that differs slightly based on the Survey Type (72 Hours & Post-Discharge). I am passing the survey type parameter through a URL & I want to hide the question & use logic on the field to determine the available questions for the survey. However, I can not seem to…
Can data shuttle accommodate below?
I need data to come in via attachment through data shuttle into a sheet like this, where if I have a new project under a person the UID is the unique identifier and it should add and child row under the parent of the assigned to team member. I will also be updating financials for each of these team members every month I'm…
Edit In PowerBI or Self Trigger Update Request?
Hi everyone, I've used Smartsheet for four years and pride myself on being able to make Smartsheet do as much as as I can get out of it... and I've hit a point I can't figure out myself! Help! I am displaying basic project info in PowerBI with a nice button to add new data to the dataset. BUT ... we want/need a…