クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

Connecting sheet to data set

回答済み
0

コメント

2件のコメント

  • 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

サインインしてコメントを残してください。