Proton sheets - backspace or change of a cell should not lose formatting + formula weirdness
I have a column of dates. If I change one, the formatting of the cell reverts to black text even though I changed it to white.
I also have a row of cells that are dark with white text. if I hit backspace on the cell (ie getting rid of the text) the cell loses its background colour.
I've tried recreating one of my google sheets in proton sheets, but I haven't managed to get very far. Having to continually reformat things is tedious. I knew that functionality would be basic initially, but this is a simple duration counter (for tracking birthdays/ages).
also...
The formula don't work the same?
have a few cells set up as follows:
=DATEDIF(A4,T2,"Y")
=DATEDIF(A4,T2,"YM")
=DATEDIF(A4,T2,"MD")
(where A4 is the "start" date and T2 is today's date.)
this spits out the years/months/days between those two dates.
But when I refer to those like so:
=D4&" is "&Q4&" years, "&R4&" months, "&S4&" days old."
(D4 being the name of the person)
it SHOULD say
Name is x years, x months, and x days old
what it does instead is:
Name is 35 years, 11 months, 17.10994212962963 days old.
Yet the day cell had no decimal points, it was simply 17. Google sheets treats this as an integer, too.
EDIT:
I noticed this is because I used
=NOW()
like I did in google, but here I should have used
=TODAY()
changing that fixed the creation of a crazy long fraction. I sort of understand the logic to this, but I feel like being able to port across from google sheets logic would be beneficial.
EDIT 2: also, if someone specifically set up a cell with, say, two decimal points visually showing despite actually being a much longer number, and then wanted to refer to that cell as part of a string like I have--- that would simply override that preference.