Hello,
I am using the DISTANCE() equation in my app.
From what I’ve read it’s only in km?
Can I not give the user a choice to choose between km & mi in the USERSETTINGS() area?
For example, ENUM (km), (mi), which would then dictate a km or mi expression?
Is there any way to control which one is being used in the app?
EDIT:
If AppSheet is default km for ANY user, regardless of USERLOCALE() that would be awesome.
If so, I can make a user setting option km / mi, and if the user chooses mi I can add an IF formula for km * 0.621371 or another virtual column with that equation alone.
Can I know…
Thank you.
It seems DISTANCE() is km regardless, so I created a virtual column for km & mi (with km * x = mi) formula. Used USERSETTINGS() to dictate which virtual column to use.
Yes that’s correct, distance is always as km.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |