Solution Center
Discussion List
-
Populating a Dropdown ListIn API & DevelopersHi, is it possible to populate the contents of a dropdown list from another smartsheet?
-
Dropdowns in a dashboard, is it possible?In Using SmartsheetI have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total …
-
Index Match Across Multiple SheetsIn Formulas and FunctionsHi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX(…
-
Automatically move rows within a single sheetIn Using SmartsheetI pulled a template for a Team Productivity Hub (https://app.smartsheet.com/b/publish?EQBCT=f29e0f2c058f4563853d6497ce554bcc) from the solution center and the sheet for tasks had originally moved completed tasks to the "completed"…
-
Trigger IssueIn Using SmartsheetFor one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number o…
-
Is anyone else experiencing "An unexpected error?"In Using SmartsheetI am getting an error for most of my reports reading, "An unexpected error has occurred running your report and the Smartsheet.com team has been notified." Is anyone else seeing this?
-
Using smartsheet-python-sdk to put data back into SmartsheetIn API & DevelopersI used the smartsheet-python-sdk (and unique API key from Smartsheet) to automatically pull data from Smartsheet into my Python script along with other data sources to create new feature-engineered columns. Is there an automatic way to now…
-
COUNTIFS between dates & criteria.In Formulas and FunctionsGreetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: …
-
What happens to my automation if I run out of rows?In Using SmartsheetHey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet to the archive sheet- we keep that for…
-
ODBC Connection with VisioIn Apps, Integrations, and Add OnsHi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to c…
