How are expressions calculated during form entry? Are the referenced columns in expressions calculated in order or are they in a way nested and calculated in each insurance. Does having a helper column help speed?
EX: column1 has an ENUM. Column2 has some if statement with a MaxRow expression based on that ENUM. And column3 has a simple expression [column2]+[column8]โฆ So, do all the columns recalculate at the same exact time, like is that MAXROW expression in column2 actually nested into the expression of column3 for calculation purposes?
Adding @Adam_Stone_AppSheet for the details
I noticed in the expression assistant that the created conversational expression had the formlas from referenced columns embeddedโฆ So it got me curiousโฆ
@Adam_Stone_AppSheet still interested in this. If my โhelperโ columns are just bloat, I want to take them out.
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |