Reference from another sheet issue

I am Making a Recipe app
I want my customers to see my products and prices on the app and make their order
I have products with prices as sheet1, ingredients as sheet2, and recipes sheets3-58.
As I update prices for ingredients on sheet2 it updates the price of the whole recipe on sheets3-58 which in turn updates the prices on sheet1. Just using =(sheet#! cell) references.
I tried to set appsheet source to Sheet1 but Appsheet is not recognizing this type of references
Iโ€™ve looked into deep links but not sure how it can helpโ€ฆ as I have a cells on 56 different sheets referencing cells on sheet2 that are being referenced on Sheet1

0 1 268
1 REPLY 1
Top Labels in this Space