Coffee cups indicate the complexity of a file, tip or article. One coffee cup is the easiest and three is the most advanced.
To download a file, click on the green arrow icon next to the listing. If there are no coffee cups
or platform icons, the listing may be an article, Quick Tip, Knowledgebase or bonus file.
Clean Data EntryTip File
Clean Returns and Spaces from One Line Fields
A common thing for users to do is enter a return at the end of a field. It’s their years of spreadsheet experience. When the cursor doesn’t go to the next field they remember to hit the tab but leave the return. I’ve published how to remove extraneous returns with an auto-enter before but lately I’ve been noticing a lot of fat fingered spaces. So, here’s an improvement to remove returns and spaces.
Header SortTip File
User Friendly Sorting
This WeekTip File
Formulas for the Previous Monday and Next Friday
Determines the previous Monday and following Friday based on the date entered. I use this calculation formula in a script that automates a find for the current week (e.g. 10/23/2017...10/27/2017). If a weekend date is specified, Saturday is previous week and Sunday is next week.
Checkbox GreenTip File
Change a Checkbox or Radio Button Icon Green
Someone emailed me asking if they could turn the checkbox or radio button icon green when it was selected with “yes”. Not the entire checkbox or radio button, just the icon and only when "yes" is selected.