I guess the answer is no, but is there a way for allowing the user to input a simple math formula, such as 1+1 that would be recorded as 2?
For context, I have an app for inputting financial statements and there are fields (e.g current assets) that would be a sum of multiple lines from the actual financial statement.
Well.. answer is no.. and yes. You could calculate the result with the Event action when the form is saved.
Interesting...and would I go about parsing it so I could calculate the result? Any simple way?
If it's always a "+", then something like..
NUMBER(INDEX(SPLIT([Text],"+"),1))+NUMBER(INDEX(SPLIT([Text],"+"),2))
If you need a - just add as a negative number
Or.. reading it from the string ๐
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |