Is it possible for AppSheet to provide a sum of numbers found in text as a value in a virtual column?
If I get a Form entry of "500 registration, 500 travel, 120 per diem" is there an expression I can use so that the aforementioned virtual column populates with 1120?
Simply providing options for separate entries for these values isn't an option, there will be too many possible variables. I didn't create the form, but I have to use its results.
Solved! Go to Solution.
Nailed it. Thank you. I've been thrown to the wolves as it were and I appreciate your help!
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |