Видео

Hello! My mum was a cardiac technician ! (also renamed to multiple other things, but she did Echos and ECGs :) ) Happy to help, email or book a 15min call here: calendly.com/bloomfield-analysis/training-branding-intro

Hello! Sorry for slow reply! The apps script is within the google sheet, so you need to open the link to make a copy of the printing invoice google sheet ("📄 Template for Printing Multiple Invoices: Make a Copy") It should warn you it contains apps script, to be safe you can open the apps script to look at it, or ignore the warning, click on unsafe, then when the google sheet opens go to the appscript

I think this is what you want: ruclips.net/video/OADE34B56hM/видео.html

Great to hear - Thank you!

Theres always multiple ways to do things, I'm glad you found the best way for you! Filter can be a good formula to use, I do use it in some videos, I can't remember which off the top of my head tho!

Thank you so much for the feedback, i didn't realise, good to know as I thought this video should be doing a bit better, I shall look into amending!

Sorry, I'm not sure what you mean! There isn't a price list function in google sheets to my knowledge. Try downloading the template that goes with the video (bloomfieldanalysis.com/sting), or let me know what sheet & cell you are referring to and I can look at the formula, thanks!

Aw, thank you so much ! Really glad this video is getting traction as it sounds like those that find it - do like it, and it really does motivate me to do more!

Glad its helpful! The best place to add quantities would be in the ingredients tab, I would add 2 new columns, one for the quantity value (1, 10, etc), the other for the metric - tin, litres, ml, etc. In the DinnerList tab, I would then add a sumifs to sum up how much is needed of each ingredient, maybe replacing the checkboxes as otherwise it could get too busy. My only question/thought would be how to adjust this if you already have some in your house? Hope that helps! And, yes, I do need to do a How To video at some point :) you are the second person to ask in the last two weeks, so thats brilliant people are watching and want to know more!

Thanks I'll try that. Looking forward to the how to video

You just need to head over to the website bloomfieldanalysis.com/sting put in your email and you will be sent all the free templates - enjoy !

You are so welcome!

Yes, you need to add another column that combines the two, e.g. if in C1, type =A1&" "&B1 - this will be value in column A then add a space (in quotations), then adds whats in B1. You'll then obviously need to look up this new column. This video has more about the "&", so might be useful: ruclips.net/video/b5aU54dL1ho/видео.html

@@bloomfieldanalysis Where do I need to put the formula in the pricelist page? That's where I tried but it didn't work. It just copied the price and the weight so I ended up with 8 1kg in the column D. Would the formula need to change on the items sheet column E? Sorry Very confused

Share your copy with me and I can make the change quick, view only will do and I can make a copy, Bloomfield.analysis@gmail

I'm so glad its been useful! And good to learn too :) I would like to do a how-to video, I think there is a lot of potential with this one, with things like quantities and calories. I haven't got many views at the moment, I think because there is a lot of other meal planners out there, but it is steadily growing. Comments, and subscribes really help, so thank you very much, appreciate the support, and hope to provide another video/google sheet that you like soon !

haha, thank you, appreciate it, and definitely know what you mean :D

Hmm... does it work if you just put one invoice number in?

@@bloomfieldanalysis no sadly I get the same message.

check the name of the folder in your google drive, or access to it. This line: var downloadsFolder = DriveApp.getRootFolder().getFoldersByName('pdf_invoices').next(); Also - Chat GPT can be really helpful for debugging code. Copy and paste the code with your amendments and it might spot something! It could be something tiny a human would find hard to find like a missing or extra bracket. You can also try downloading again and making changes. Good luck - hope you find the issue

@@bloomfieldanalysis it was the name of the folder!!! Thank you SO much! this is so incredibly helpful!

@@tinastriebel8100 Brilliant! Glad to be of help 🐝

I'm very sorry to hear that, I thought it was clear that it was "print to PDF" - it does say "Printing PDF invoices" on the thumbnail, the picture also shows PDF files, and the description says "Google Sheets to PDF". I think you'll struggle to code printing directly to the printer, it will likely to depend on the printer, its setup and numerous other factors. And will always be manual to have printed paper versions. You can automate printing to PDF and emailing out. Thank you for your feedback. Good luck finding what you are searching for. If you do find it, maybe post on here so others can also find it in case they are also looking for the same thing.

Hello! Yes, just get rid of the 10, So C2:C then it will look up to the end :)

(in google sheets, excel isn't as clever, so just pick a large range and go to 1000 or something)

@@bloomfieldanalysis Ah, good to know. Thank you!

Hi! Yes, I am sure I can help, email me at sarah@bloomfieldanalysis dot com (hiding email from bots).

You mean multiple sheets (tabs) within one spreadsheet (file), or multiple spreadsheets (files?) , or databases held in something other than google sheets? The first (multiple tabs) should be easy, but might be easier if you put them on one combined tab. The second (multiple google files) is much easier in excel! where you can just use the = and click on the other spreadsheet! In google sheets you want to use the "importRange" function. Then bring ALL the data into the one place. Otherwise if you want to do any kind of formula you need to use importRange in every formula which is super hard! To use importRange click in cell A1 in an empty sheet, write =ImportRange("full URL of other spreadsheet, include speechmarks!","Tab Name and Range, again with quotations") example =ImportRange("docs.google.com/spreadsheets/d/abcd123/","Sheet1!A1:Z100") You may need to grant access first time. If the databases are in another file type, you'll need to provide more info Hope that helps :)

oooh, it thinks you are european, where are you based? You should be able to change your location in settings to UK or US, where commas are the norm :)

Hi @bob.bobman, I am a junior software engineer and have a years experience in google appscript I can help you out

do you have number i can contact you on

@@Hamza-pd6oq send me a link to your LinkedIn or similar so I can verify your identity and credentials please.

@@Hamza-pd6oq to be clear I need automated reports generated from my existing data table and have them saved to a user specified Google drive folder, if the door agent exist it should create it. Also have auto generated emails to a different recipient for each report originating from my Google email.

@@bob.bobman cool I can have a look for you

Hello! Sorry for slow reply, try this video ruclips.net/video/OADE34B56hM/видео.html :)

Try this video :) ruclips.net/video/OADE34B56hM/видео.html

@adventuregutta Love the challenge and the use for the leaderboard ! I suppose the main difference is you want to use a number rather than a category. So when in google forms you need to select short answer rather than dropdown. The bit that will probably be tricky is getting google sheets to recognise its a number, which will be really hard if people write things liks 2,200 steps - the words steps and the comma could stop google sheets seeing their input as a number, and will not let you add them up. But as its family shouldn't be too hard to control this with clear instructions! Then should be able to sumif per person. Will require a bit of testing though. If you are still struggling, i'd go back to dropdown/categories similar to the drum leaderboard and give points depending on steps (1-2000 steps = 1 pt, 2001-5000, 2pts, etc). There is also the app "WeWard" which will add up your steps, and you can add family as friends to track and it will give you a scoreboard, with filter "this month". You can also collect points on here and redeem for yourself or charity.

YaY! Great, so glad uit was useful, thanks for the sub :)

Nevermind I've just found the video where you explain it. Incredibly helpfull information. Thank you so much

great - glad you found it ! sorry for slow response 😊

Yay! 😊 Good to hear 🐝

Have you looked at the main videos on RUclips.com/@BloomfieldAnalysis ? I struggled to fit everything in the shorts - both screen size and 1min limit !

Brill! Glad it was useful! :)

unfortunately thats not going to work, you are indexing just one value 'Invoice F28'. When using index you are looking for something in a table (row or column) then then finding the specific value with match. If you only want the value in Invoice F28, then a single = will do that. But I dont think thats what you want. If I'm understanding you correctly, you want the total in your database column, for every invoice, not just the one selected on the invoice tab? Unfortunately, you can only see the total when you've selected the invoice number. So you can't read them all at once. The best thing to do is to calculate the total in the database, rather than in the invoice. Or, you can create apps script that runs through all the invoice numbers and adds their total to the right column. You dont want to manually copy and paste them over! I can have a think and a play, to see if theres a way to do this quickly... Am I understanding what you want tho?

@@bloomfieldanalysis Wow thank you! Yes that is exactly it. Then I could hand a list of the database to my book keeper when tax time comes if the value of the invoice is included.

@@user-dm4vs7bx2e Definitely something I was thinking of too! I can feel another video coming 😊🐝

Hi @pintorthepintor3964 ! Yes, sorry, that was a bit quick that part, I copied and pasted from a list I made earlier, copy (Ctrl+c) and paste (Ctrl+v). If you are creating your own list it will take longer if you dont already have a price list. One watch out - make sure you enter just the value, not the currency, as sometimes this will be seen as text rather than a value, and it wont let you do calcs from it! Hope that helps.

Haha! My pleasure 😊

Great to hear - thank you!

Haha, thank you! Thats kind of the style I was going for :D

Glad its helpful, sorry for slow reply, its difficult to say what the issue without seeing it. On the main calc tab, you should have Rank (which includes ties, e.g. 2 people can be at 3). Then position, which avoids ties, so 1 to the number of people (N). Then on the leaderboard tab you can type 1-N. Then to match the person to the position, XLookuo is probably the easiest formula to use. If you still need help, feel free to share with me, or send a copy over. bloomfield.analysis at gmail.com

@@bloomfieldanalysis I think I figured it out! Thank you!

So glad to hear it !

Thanks :D !

@SkyGateFurniture Watch this video: ruclips.net/video/OADE34B56hM/видео.html Or go to bloomfieldanalysis.com/sting to download the example : "Invoice Template with Double Dropdown Price Lists and Items Tab", by downloading you will also be subscribed to our newsletter

Then adding the row number will make it unique :)

Hmmm... thats difficult because its more a format change than the underlying value you want to change. Well, in your example above, both the format and the value would need to be divided by 100. It is possible through apps script but I feel that would be overcomplicating. Whats the reason for it? A discount can be a value or a %? If so, I would have both options available, then hide whichever is unnecessary. Hiding can be by formatting (so white text on white backgound) when not relevant. I think you can achieve the result you want but just not how you wanted to originally.

Hi @ibz844 You should be able to get anything in the spreadsheet to another using IMPORTRANGE, not sure why it wouldn't be working... maybe the sheet id? or making sure you have verified access through the importrange - google are getting more fussy about access... although if you own both spreadsheets it seems overkill! Why do you need a separate version? You should be able to access on your phone using the google sheets app, and to cheat, I would probably screenshot the invoice page, and crop it, to send on the go. And make sure invoice number is on a dropdown. But that might not be what you want?

@@bloomfieldanalysis Yeah, it's just a separate, invoice only, workbook that I can export as a PDF, you can't export single sheets on the iPhone google sheets app. The IMPORTRANGE works normally, but not in conjunction with MATCH. Not to worry, thanks for your response

@@ibz844 Ah, thats annoying! One way round, that I have working for another client, is that you do the match function elsewhere in the invoice sheet. We call this "internal reference" - or you could hide it somewhere. This will get you the row number, that you can then put in the index match function, like this: =IMPORTRANGE("docs.google.com/spreadsheets/d/[sheet id]","[tab name]!h"&E6) - this is looking in column h and the row number is in cell e6. Hopefully thats more helpful 😊🐝

So, I got it working, I rewrote the formulas, I think I'd missed some &s and "s. But it's working now. Thankyou so much for your help!!

@@ibz844 Great 😊

Aww, thank you ! I do try to reduce the fluff :)

Fantastic - appreciate your comment ♥🐝

So glad you've found it useful ♥🐝

Good Question! You need to put the Name & Description together in the items/price list tab, so, e.g. if Name is Column A & Description in column B, Price in Column C, You can use Column D. D2=A2&B2. This will make ItemDescription. To make it a little neater add "-" between them, so Item1-Small: D2=A2&"-"&B2. Then you need to lookup up this value in the invoices tab, you can put it into the formula or somewhere hidden/not printed in the invoices tab :)

Hi! This is our video on printing invoices to PDF: ruclips.net/video/oNzaij7f5yM/видео.html Unfortunately, if you are on the free version, Google Sheets has a max you can do at once, but you can do about 6-8 at a time.

Use apps script on google sheets extensions.

Yep - that works for May :) Its great to have a solution for any date though, so you only ever have to change one initial date, and everything else automatically updates. In retrospect May wasn't a great example, as if you have literally any other month, you can show that MMM = just 3 letters, e.g. Apr but MMMM = full month, e.g. April :) Only so much you can fit into a short though! The full create an automated timeline video can show you a lot more ruclips.net/video/Ho7EWMmPYZY/видео.htmlsi=mFAFTRfZ_tkTinux