Smartsheet connector to pull in Sheets from Folder into one DOMO Dataset

GADPEPPY
GADPEPPY
in Connectors

Hello All,

 

I am looking to see if someone is using DOMO and Smartsheets. Have you collected a large number of sheets in DOMO and created visual of a PMO dashboard? Are you able to get multiple sheets from Smartsheets and placed into DOMO in a single dataset. The current method I am using is to get each sheet as a SOLO connection to DOMO. Then use "FUSION" to load all the datasets (Smartsheets downloaded) into a single Dataset. Then report from this single dataset.

Any feedback or thoughts would be helpful.

Thanks!

Gaetano DiSalvo

Comments

  • ST_-Superman-_
    ST_-Superman-_ 🟤

    I think you are going about it the right way.  Each sheet in Smartsheet is brought into Domo as a separate data set.  If you want some more control over how the datasets are getting joined, you can join the datasets in MySQL or in ETL.  I think there are still some limitations to datafusions (you can't use them as an input for another dataflow).

     

     


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________

Categories