Is there a way to lock some fields to prevent editing by mistake?
when i need to prevent users editing a field i make a second version of that column which is a formula that displays the desired column.
then i hide the original editable column and only show the formula version.
because its a formula. the user cannot edit it
That’s a great idea…thank you!