Question for the formula using in the sheet


I have some issues with my app. Could you please help me resolve this.

My app will use functions Query and Importrange to take the data from another sheet to the sheet used for App making. It has some problem such as:

  1. It cannot show the interface of the app. I don’t know if the formulas have affected to the app. Could you help?

  2. I could’t add the Action based on the Column I need because I have used formual for that column and it not show on the setting part.

Could you please let me know that using formual to automatically take the dât from another sheet is the good choice for the app? Thank you.