I have a roster with first and last names. The next sheet is a sign in sheet. However, we are required to provide the option of preferred names instead of the legal first names.
For example, my name is Michael, but I go by Mike.
I still need the legal name for certification purposes, but need the preferred name on other things.
On the sign in sheet, it should automatically say Mike Yates instead of Michael. Can make it do it once, but I need a formula that can determine if there is a value in the preferred name field, and if not, defer to the first name.
I could just give everyone a preferred name, and make it their legal name if they don't specify one, but I'm not the only one who manages the spreadsheets, and I promise you it's either to magic happen with Microsoft than it is to get people to do take an extra step.
I keep getting an error with the xl2bb, so you'll have to live with snip-its.
For example, my name is Michael, but I go by Mike.
I still need the legal name for certification purposes, but need the preferred name on other things.
On the sign in sheet, it should automatically say Mike Yates instead of Michael. Can make it do it once, but I need a formula that can determine if there is a value in the preferred name field, and if not, defer to the first name.
I could just give everyone a preferred name, and make it their legal name if they don't specify one, but I'm not the only one who manages the spreadsheets, and I promise you it's either to magic happen with Microsoft than it is to get people to do take an extra step.
I keep getting an error with the xl2bb, so you'll have to live with snip-its.