Hi everyone,I’m working on an AppSheet app that involves three main tables:1. Project Table – Stores project metadata like Project ID, Component Team, and Main BU.2. Weighted Score Table – Stores user inputs related to materials for each project.3. P...

I have a table with around 1 million rows, and I need to calculate and update the weighted score based on project category creation. For a single project, the maximum number of rows will be 100,000.I have three tables involved:1. User Table – End use...

I have a table with around 60,000 rows, and I need to calculate and update a weighted score based on the values of two columns: Supplier Spend and Total Impact Supplier Spend.I’m using the following formula in the Weighted Score column:IF([SUPPLIER_S...

I have a Source Table (read-only) with dynamic data, including columns for Category (ENUM) and Business Unit (ENUM_LIST).In my Project Table, I create new projects, each associated with a specific Category and Business Unit.I need to transfer data fr...