Lock data entry of one cell based on the contents of another cell

Topic Labels: Base design Data Formulas
122 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi folks, appreciate any help you are able to give here....  I have a base where the users enter pricing information from suppliers.  Sometimes the pricing is given to the users including tax and sometimes excluding tax.  At present all data is entered excluding tax forcing a manual calculation which is clunky.  I would like to have an either/or useability whereby the price ex tax cell is locked for input if the price inc tax cell is entered and vice versa... is this possible?

Thank you 🙏


0 Replies 0