myBizConcierge

In Google Sheets it was previously a bit complicated to grab a data set and group it by the date assigned when the data is originally submitted in the date/time format which is what happens when using Google Forms or any date from a submission process.

Australian Landline or Mobile (Including Area Code) I've had some issues with the Australian landline or mobile regular expression in my previous post as more numbers have been made available so I've started using this expression instead: ^\({0,1}((0|\+61)(2|4|3|7|8)){0,1}\){0,1}(\ |-){0,1}[0-9]{2}(\ |-){0,1}[0-9]{2}(\ |-){0,1}[0-9]{1}(\ |-){0,1}[0-9]{3}$

GSuite Forms added their regular expression functionality a while ago but finding the correct combination for your scenario online can be cumbersome if you're not heavily into a language that makes use of regular expressions in it' entirety and Google doesn't seem to provide relevant samples probably because the combinations can be vast and "why don't you just Google it?". Below are some details I found useful for enforcing correct number formatting when entering details in some Google Forms I've had to create: I found "The Cheat Sheet - Javascript regular expressions " useful in resolving some of these: http://cheatsheet.zemplate.com BSB ^\d{3}-\d{3}?$ This uses a strict (3-3) format i.e. ###-### TFN Australian Tax File Numbers are  9 digits in the format of (3-3-3) ^(\([0-9]{3}\)|[0-9]{3}-)[0-9]{3}-[0-9]{3}|(\([0-9]{3}\)|[0-9]{3} )[0-9]{3} [0-9]{3}|(\([0-9]{3}\)|[0-9]{3})[0-9]{3}[0-9]{3}$ ABN Australian Business