I am new to writing long form expressions and linking data together within Appsheet and I was wondering if any of you could point me in the right direction.
In the example screenshot, I am trying to have Column A be changed to what is listed for Column D. Column A is a REF to another sheet. Column B is also a REF to the same sheet as Column A. Column C is the data being input by me and Column D is a subtraction expression that is (Column B - Column C). I would like for it to function as (Column B - Column C = Column D, which changes the value of Column B when saved.) Is there a way to make something like that work? In my limited experience, I have not had any luck. Any help would be appreciated.