User Profile
Rebecca_L4
Copper Contributor
Joined Oct 15, 2020
User Widgets
Recent Discussions
Re: #SPILL! From a Referenced Merged Cell.
SergeiBaklan Thank you. I'm sorry for the incessant questions, but here's another: I formatted the cells for date, but I still have to type them in with slashes (ex. 10/15/2020), and I don't understand why. I am wondering if there is a custom one that will work like the phone number one. For phone numbers, I just have to type in 10 numbers and it automatically puts them in the correct form of (123) 456-7890.19KViews0likes4CommentsRe: #SPILL! From a Referenced Merged Cell.
SergeiBaklan THANK YOU. Yes, that worked perfectly. Now I have another question that maybe you can help me with. I have a cell on my spreadsheet that should show someone’s age (it should show either current age or age at death, whichever applies). I am trying to find a formula that would calculate these scenarios. I believe it should be an if/then type statement, because whatever the answer, it should populate this one cell. My spreadsheet currently has one cell with the today’s date (DATE), one for the date of birth (DOB) and a cell which would only be populated if the person is deceased (DOD). So, theoretically the age would be found using combinations of those three cells.19KViews1like6CommentsRe: #SPILL! From a Referenced Merged Cell.
SergeiBaklan I am trying to populate an empty merged cell with a merged text cell from one sheet to another. It is now displaying #Value! instead of the name I am trying to reference. For reference, the formula I am using is =@'Client Info Sheet'!B6:D6.19KViews1like8Comments
Recent Blog Articles
No content to show