Shopping Cart Life Span: How soon does your shopping cart expire for anonymous users? More than a few shopping systems use Session variables for tracking cart items, and expire within hours, especially for users behind prozies that change IP addresses often, thus rendering the current Session invalid (think AOL). Several studies point to the fact that customers will wait as long as 4 days before deciding to buy, and if the item they were looking at is still in their shopping cart, you just saved them several steps and increased the possibility of conversion substantially.
Checkbox Form Object - Use the checkbox form field only if you are wanting to add interactivity to your checklist. The checkbox form field, found in the Forms toolbar, can link to a cell in the spreadsheet without requiring any Visual Basic programming. The linked cell will be a boolean value TRUE or FALSE. Like the drawing objects, working with a large number of checkboxes can get messy.

Google Sheets beat Microsoft to the punch and introduced a Checkbox as one of the Data Validation options. You can go to Insert > Checkbox to quickly create one, and you can customize it by going to Data > Data Validation. I've updated most of the Google Sheets versions of my checklists to use that feature. I hope Excel gets smart and introduces a similar feature some day.
In professional diving, checklists are used in the preparation of equipment for a dive, and to ensure that the diver and life support systems are fully prepared before they enter the water. To a lesser extent, checklists are used by a minority of recreational divers, and by a larger proportion of technical divers during pre-dive checks. Studies have shown checklists to be effective at reducing the number of errors and consequent incidents.
×