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 ...
Excel Add In
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.