I think I had a similar situation. I was using a “single drop down” for ratings (e.g. “0 - I do not know”, “1 - I know a little”, “2 - I know much”). To run calculations on that, I created a formula column and used a series of VALUE and LEFT functi...
I agree, I have been baffled several times by “missing records” only to realize they are stuck down at the bottom. It seems intuitive that a sort would be applied upon opening the view.
Damon_Talbot:
For paid teams, you will be charged the per-user, per month fee for each person you’ve invited to collaborate on bases belonging to that team. You will not be charged for read-only collaborators.
I’m very much interested in this ...
This is what I have too. Mine is a member roster, so the ID field is the FORMULA. LNAME & ", " FNAME field. It works pretty well. But, if they added this field type, I’d probably migrate to that.