Solution Center


Discussion List

  • Populating a Dropdown List
    In API & Developers
    Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
    8733 21
    8.7K views 21 comments Most recent by Pam Ferguson API & Developers
  • Dropdowns in a dashboard, is it possible?
    In Using Smartsheet
    I 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 …
    1604 13
    1.6K views 13 comments Most recent by Gaurav K Using Smartsheet
  • Index Match Across Multiple Sheets
    In Formulas and Functions
    Hi 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(…
    15 3
    Answered ✓ 15 views 3 comments Most recent by MVP OPS Formulas and Functions
  • Automatically move rows within a single sheet
    In Using Smartsheet
    I pulled a template for a Team Productivity Hub ( from the solution center and the sheet for tasks had originally moved completed tasks to the "completed"…
    Answered - Pending Review
    10 2
    Answered - Pending Review 10 views 2 comments Most recent by Karina Using Smartsheet
  • Trigger Issue
    In Using Smartsheet
    For 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…
    36 3
    Answered ✓ 36 views 3 comments Most recent by MVP OPS Using Smartsheet
  • Is anyone else experiencing "An unexpected error?"
    In Using Smartsheet
    I am getting an error for most of my reports reading, "An unexpected error has occurred running your report and the team has been notified." Is anyone else seeing this?
    26 5
    Answered ✓ 26 views 5 comments Most recent by Genevieve P. Using Smartsheet
  • Using smartsheet-python-sdk to put data back into Smartsheet
    In API & Developers
    I 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…
    Answered - Pending Review
    28 1
    Answered - Pending Review 28 views 1 comment Most recent by ericncarr API & Developers
  • COUNTIFS between dates & criteria.
    In Formulas and Functions
    Greetings 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: …
    3983 39
    4K views 39 comments Most recent by WendyR Formulas and Functions
  • What happens to my automation if I run out of rows?
    In Using Smartsheet
    Hey 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…
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • ODBC Connection with Visio
    In Apps, Integrations, and Add Ons
    Hi 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…
    255 4
    255 views 4 comments Most recent by C. Powell Apps, Integrations, and Add Ons