Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago

Dashboard that runs a spreadsheet with a combo box error

Originally posted by Andrea Tout

6/26/2018

Hey there! I am trying to do a spreadsheet form. So the form template is built as a dashboard because if you build a spreadsheet form, any prompts will show up as a dialogue, not be nested on top of the form. So instead I am making a dashboard that runs the spreadsheet with a combo box. It works for the most part, but every time I run it I get this error, but when I make a selection, in the combo box, it all runs fine. Has anyone seen this? I want to try this for my users but the error makes it look wonky.

 

Excel Add In

1 Reply

Sort By
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    5 years ago
    Originally posted by Andrea Tout

    It is actually the first time that a user logs in! So it doesn't error out when they log out and log back in or change months or anything.
    But I did find the KB article in teams and it worked like a charm to nest the parameter in the spreadsheet. It was very easy too, you just place a cube view with the potential selections on one sheet, set up a list in excel that uses the rows, and then nest the parameter (without pipes and exclamation points) in the named range of the list.