Fair enough you got me there. What I should have said was equal to the same “ambient temperature”.
We could all take comfort in knowing no matter where your friends are in the world we all feel -40 c and -40 F the same.
Fair enough you got me there. What I should have said was equal to the same “ambient temperature”.
We could all take comfort in knowing no matter where your friends are in the world we all feel -40 c and -40 F the same.
Except for some of us that never happens, and never will (I hope)
Probably the best reply, ahahaha
@Jeff_Hager @ThinhDinh or whoever knows this:
Can Math column count how many characters we have in a text/number column?
I’ve already requested, but I super needed now
I don’t know about the Math Column in Glide, but the “=LEN()” function/formula will count the characters in your GSheet.
Yeah, the point with formulas is the spreadsheet response time
Yeah I know what you mean…whereas the Math Column would be instant…
Not easily, but if you’re willing to put in some work, this is the only solution I know of that’s contained within Glide and shows a count in real time (Not in add/edit/form mode).
If you are only counting characters on numeric columns, I think you can skip the ‘1’ column and the template column and just do the math directly on the numeric column.
Greetings,
I have a problem, I’m trying to add dates, but specifically months. Ex: today (02/05/2021 + 18 months) trying to do it by MATH, but the expressions DATEM or Month are not valid.
Can someone help me?
Sorry for the writing I’m using google translator …
Here you go. Just use 1.5 years for the number of years, or you can take your number of months and divide by 12. Same thing either way.
Edit: I have some updates to this formula that I’ve explained in the post below. You’re requirement to back Feb 29th by a day if it’s not a leap year does complicate it a bit, but that’s not a problem. It just makes for a formula that’s much larger. Here is the formula if we were to allow Feb 29th to roll over to Mar 1st. ((Now-DAY(Now)+15)+(Years*365.25)) - DAY((Now-DAY(Now)+15)+(Years*365.25)) + DAY(Now) [image] To get the leap year date of Feb 29th to back date to Feb …
Quick Q - can’t think…
Using 'glide tables’
I need to calculate the day from a date so ‘NOW’ = ‘Wednesday’ (in the uk)
Day(NOW) will give you the day (number) of the week, then plug that into an ITE
Used this in a recent app for a client — check it out:
Makes sense, I think
‘Now’ is always going to be ‘Now’