I've watched a load of your videos (and other peoples) and off I went and built a database form first time ever, and it kinda works lol, until I added a search and then it sometimes works and sometimes not. Its for my Movies and TV series, so in the title column some have numbers for eg. the TV series "24" and that breaks it. the code I'm using is this =QUERY(Data!A1:J,"SELECT * WHERE LOWER(E)= LOWER("""&B2&""")", 1) can you tell me how to include numbers
hi... I have a problem.. I have a dependent dropdown list. The error comes up when i change the initial dropdown and the dependent list does not have that value anymore. If gives an error input value
My Google sheet is broken When I move the mouse it selects the area by itself even though I didn't press any shortcut, please help me to fix this. This error only appears on Safari browser and the machine I'm using is macbook pro 2012. Many thanks.
@@ProlificOaktree Thanks for the response. I have changed the locale to my current country. This is a shared sheet and only some of them are experiencing this, the rest is fine.
I need help. I created a check register in google sheets and the only formula I can’t figure out is how do I display he current balance at the top of the register so that I don’t always have to scroll to the bottom! I get #Error! In the formula box
balance gas grocery liquor insurance misc and utility restaurant balance pension $1,000.00 $1,000.00 $1,408.92 $2,408.92 #VALUE! #VALUE! $0.00 $0.00 $0.00 I keep getting the value sign trying to subtract the six cells any help?
Thank you for showing me how to resolve the error message!!!
Anytime!
Super helpful! Thank you. This worked. 🙌🙌
Glad to hear it!
I've watched a load of your videos (and other peoples) and off I went and built a database form first time ever, and it kinda works lol, until I added a search and then it sometimes works and sometimes not. Its for my Movies and TV series, so in the title column some have numbers for eg. the TV series "24" and that breaks it. the code I'm using is this =QUERY(Data!A1:J,"SELECT * WHERE LOWER(E)= LOWER("""&B2&""")", 1) can you tell me how to include numbers
God bless you! You helped me a lot.
Solved my problem! Thanks for the hidden space "text"
Coma instead on dot also help solving this problem. depend on the language i guess.
hi... I have a problem.. I have a dependent dropdown list. The error comes up when i change the initial dropdown and the dependent list does not have that value anymore. If gives an error input value
Thank you your work around using sum working for me.
You're welcome!
My Google sheet is broken When I move the mouse it selects the area by itself even though I didn't press any shortcut, please help me to fix this. This error only appears on Safari browser and the machine I'm using is macbook pro 2012. Many thanks.
ok, i just pressed SPACE and now i know why lol, thanks for the help
Happy spreadsheeting
When I insert current date and time in Google Sheets, it displays as "№". I'm using a Macbook and I can't find a solution.
Wow. Maybe check the locale settings in Sheets. Maybe it is set for a country different that where you are.
@@ProlificOaktree Thanks for the response. I have changed the locale to my current country. This is a shared sheet and only some of them are experiencing this, the rest is fine.
I need help. I created a check register in google sheets and the only formula I can’t figure out is how do I display he current balance at the top of the register so that I don’t always have to scroll to the bottom! I get #Error! In the formula box
It's not a formula. Just select the row go up the view and then the freeze row should be when the options
- i have a problem i divide a percentage to a number ( 60%/5)and i get value problem whats the solution ?!
% is part of formatting, not part of the value. Make it .6/5
In my google sheet i am having number like 9,58,000 but it is still showing the same above error, also i have changed it to number format. Pls guide
You can't type commas into a number.
Life saver. Thanks.
on google sheets when using the google translate option i get an error #VALUE! any idea how to resolve tahnks
No, but you can probably hover over the cell to get a bit more info.
balance gas grocery liquor insurance misc and utility restaurant balance pension
$1,000.00 $1,000.00 $1,408.92
$2,408.92 #VALUE!
#VALUE!
$0.00
$0.00
$0.00 I keep getting the value sign trying to subtract the six cells any help?
Hope Google sheets can reach something called ignore error like MS Excel
Well, there is an ISERROR function that's pretty handy.