I’m attempting to load a business inventory. Initially, I intended for C5 and F5 to be vacant until B5 was filled with customer names. I’m currently using =C5-D5+E5 for F5 to compute the remaining load balance after the load is initiated. The value of C5 is (=F4), which is obviously dependent on the value of F4.
- What’s your question?
- Have you considered building your logic in av Glide Table rather than in Google Sheets?
- What will be the use experience? How will the data be populated in your columns?