|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

Connecting sheet to data set

Répondu
Demande de démonstration

Hi,

I've created a spreadsheet that's connected to a query. I'd like to create a separate connected sheet to this sheet. I've published the spreadsheet connected to the query, but in my new sheet it says I'm unable to connect to a data set. 

Can anyone help me in what step I missed to connect the sheet?

Some additional context, I'm looking to add formulas to this connected sheet, not doing this to the original sheet, as any refresh of the data would delete the formulas. But open to other ways of doing this if possible.

Thanks,

Johnny

0

Commentaires

2 commentaires

Date Votes
  • Paige Ringhofer

    Hi Johnny,

    Welcome to the Community and thanks for reaching out! I have consulted with some of our experts and they have suggested putting formulas directly on the sheet connected to the query and locking those cells so they don't get overwritten when you refresh your query. Please let me know if there is anything else I can help with!

    Cheers!

    0
  • Johnny Koung

    Hi Paige,

    In order for me to do this, I wanted to add some additional columns to the left of the data to lock. It seems I don't have the option to add columns when the sheet is connected to a query. Any suggestions on how I can do this? 

    Also, I was wondering if locking the cells is the best way to solve this. The data coming in from the query can have a different number of rows. This would mean that I would have to adjust the formulas every time there are more rows in the data.

    0

Vous devez vous connecter pour laisser un commentaire.