Forum Discussion
Check Boxes and Populating other cells
I'm trying to create a new sales order/packing list form for my company.
Is there a way to check a checkbox in one area of the spreadsheet and have other information or formulas populate another area?
see picture please.
With values in a cell you would normaly use an =if( ....) construction to populate an specific other cell. With checkboxes you probably need to use a step in between. This video shows the step in between: https://www.youtube.com/watch?v=bWlnIhCMjfM
If you need more help attach your spreadsheet.
Regards, DM
