Apologies if this is obvious, I am new to Excel programming.
I have a table of Task where a user can add, edit an remove task (one task per row). On add (from within Glide) I need the row to contain certain formulas that refer to other cells on the same row. I am not clear how I go about doing this?
An example of a formula I need to input is
=IF(O2=0, 0, POWER(2,O2-1))
which is attempting to calculate a exponential back off based on how many times
O2 has been deferred or nah’d. I don’t believe that the nature of the formula is relevant here, I am just providing it as a example.
There is something called an ARRAYFORMULA that you can use. You can also just drag the formula all the way down using the bottom right corner of a cell. I notice that glide then assigns each row a row-id as the row now has content. Unfortunately this means that glide will then assign new task to the next fully empty row. This makes sense, but of course the next empty row is the one that does not have the formula.
I thought maybe I could simply input the formula from within glide. So I tried adding a text input component and then inputting a formula directly as a default value. I then set the display to only occur when row-id is equal to NOT_A_ROW_ID. This means it isn’t visible. However, after adding a task (row) using glide, it appears that glide quotes the equal sign to make it a literal value, so I don’t think that can work. I do notice that I can use the
SPECIAL VALUES input component to input a
Current Date, but I don’t see any
SPECIAL_VALUES to input a formula?
Those are the solutions I have tried so far. I am curious if I am going about this the right way?