Видео

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

Aww, thank you! What were you thinking with the invoice tracker? what would you need? A dashboard / summary - or highlighted overdue ?

@@bloomfieldanalysis mostly highlighted overdue

Hi @AnahiSidonio-uc5dh - you are in luck ! I've literally just published a short on highlighting overdue invoices: ruclips.net/user/shortso0XZxqII5y4?feature=share This is excel, its the same formula in google sheets, just under Format/Conditional Formatting/Custom Formula. This video may also be of use: ruclips.net/video/nu06D2Qj8No/видео.html I should be back to longer videos shortly, just testing whether shorts can help get me to 1000 subs a little faster, less than 20 to go !

Yes, it is! I like to create a new number based on the date (e.g. year, month, date), and also the row number. Row number will ensure its unique. Something like this, if your invoice date is in column B: ="INV-"&text(month(B36),"00")&text(day(B36),"00")&row(B6) The text([ ],"00") ensures number is always 2 digits so its neater, i.e. dec is 12 and January is 01 rather than 1. Row number itself would also be fine, but dates are easier for me to interpret.

@@bloomfieldanalysis Bro!! Please make a video for us highly requesting. How to change the invoice automatically . Thank you ❤️

Yes, I can do that - you and hundreds of others better watch though - haha! I've added it to the list. I have a couple of shorts coming up, which I'm hoping will help up the subscribers a little more, as I'm getting very close too 1000 subs! But definitely more long form after that.

@@bloomfieldanalysis Love From Bangladesh

@mustasimarif7708 I Hope this helps ! ruclips.net/video/b5aU54dL1ho/видео.html

Hi! Yes, sounds like you've watched the most relevant videos :) Always best to have unique quote numbers, although if you are printing/downloading to pdf at least you have a back up copy. Should be easy to add more items, have you seen this video? ruclips.net/video/OADE34B56hM/видео.htmlsi=_GPOUMZEFwBSCI2k We can also create bespoke solutions for you, check out our website bloomfieldanalysis.com/sting

Hmmm.... in the responses sheet do you have duplicates? What is duplicating - the name or the result? for unique names, try "unique", if its the result check the responses sheet - hope that helps

Go to Bloomfieldanalysis.com/sting

Think what you need is this video 😊Create a | Automated | Double Dropdown [Dependent] Price List | Google Sheets / Excel ruclips.net/video/OADE34B56hM/видео.html

Two options : if you don’t want cells highlighted in a specific place, make sure it’s not included in rule. But I think what you really want is any empty cell to be white / whatever the background colour is ? In that case, add a new conditional formatting rule saying if empty =“” then white. Make sure this rule is first in the rule hierarchy so it’s more important than today’s colour.

If you are still having issues, try downloading the template (bloomfieldanalysis.com/sting), and then compare that to what you have done, or start from that, and adapt it, it could be something really small that’s hard to see

@@bloomfieldanalysis Yes! Thank you! That's what I did. I edited the downloaded sheet. Thank you very much!

Yay! Thank you! 😊

If you have more than 10 items I would definitely recommend reducing the information at the top so it takes up less space and increase the space for more items. That’s the great thing about learning to make them yourself - you have full control to make it suit you 😊🐝

Glad it was helpful! Yes, I love playing around with excel & google sheets, especially building little tools 😊

You are welcome :)

That's a great idea! Thanks for the feedback :)

It’s easy to change the question type in the form, but how will you score it ? Will it be like a quiz and you have to give the exact answer? That will be fine because you can score based on an exact answer, but typos/ additional information would make it hard to match their answer with the exact one.

My pleasure 😊

So you want to manage your customers and candidates using Google sheets ? Yes, I think that would work nicely ! I would start with a tab for customers, one with candidates, one with jobs. Difficult to say more without knowing more.

Awww, thanks ! Glad it’s helped 😊

Hi! You can download lots of templates on bloomfieldanalysis.com/sting :)

Great to hear - thank you ☺️

Glad it helped ! Download the full template from BloomfieldAnalysis.com/sting (it’s free!) change the initial date in the plan tab and the rest will flow through 😊 all changes can be made in plan and it other tabs are automatic !