How To Videos And Tips
How To Videos And Tips
  • 1 025
  • 5 797 777
How to Convert Currency in Monday.com
If you need to convert currency in Monday.com, you currently need to use formulas to do so. These work in a similar way to formulas in Microsoft Excel.
0:03 Introduction to my Purchase Board
0:56 Method 1 (2 currencies only, IF)
5:22 Troubleshooting formula errors
5:56 Method 2 (multiple currencies, SWITCH)
8:43 Adding $ sign and number formatting
Here are some formulas you can copy-paste. Method 2 is easier to use than Method 1:
Method 1 (2 currencies only):
With $ sign in front:
TEXT(
IF({Currency}="USD",MULTIPLY({Quote Price},1.34),MULTIPLY({Quote Price},1))),$##,##.00)
Without $ sign in front:
IF({Currency}="USD",MULTIPLY({Quote Price},1.34),MULTIPLY({Quote Price},1))
Method 2 (multiple currencies):
With $ sign in front:
TEXT({Quote Price}SWITCH*({Currency}="USD",1.34,"CAD",1,"EUR",1.47,"GBP",1.71),$##,##.00)
Without $ sign in front:
{Quote Price}SWITCH*({Currency}="USD",1.34,"CAD",1,"EUR",1.47,"GBP",1.71)
Add text formatting to a formula:
TEXT((Formula),"$##,##.00")
zhlédnutí: 310

Video

How to Understand the Kentei Level 10 Practice Exam - Part 2
zhlédnutí 47Před 8 měsíci
The Kentei Level 10 exam is the easiest of the Kanji tests, and is taken by 7-year-olds in the Japanese schooling system. In Part 2 of this video I go through the practice exam paper in more detail, translating each question and some of the more difficult exercises to help you through some of the more difficult vocabulary. As there is only one practice paper available, I recommend trying to sit...
How to Understand the Kentei Level 10 Practice Exam - Part 1
zhlédnutí 134Před 8 měsíci
The Kentei Level 10 exam is the easiest of the Kanji tests, and is taken by 7-year-olds in the Japanese schooling system. In this video I go through the practice exam paper uploaded by the test organization to help you understand the different types of questions they ask. It's a 40-minute written test and you need at least 70% score to pass (105 out of 150 points). You can download a copy of th...
Samsung Dishwasher DW80N3030US Features
zhlédnutí 1,3KPřed 8 měsíci
0:20 Exterior Buttons 0:46 Cycles 1:42 Water Use, Running Time and Temperatures 2:15 Options 2:55 Locking the Touch Panel 3:36 Delay Start 3:48 Start, Cancel & Drain 4:50 Cycle Stage Indicators 3:55 Detergent & Pre-Wash Dispensers 6:59 Racks and Cutlery Basket Useful Features
How to clean Samsung Dishwasher Filters and Interior Model DW80N3030US
zhlédnutí 479Před 8 měsíci
0:05 Sanitize Cycle 0:24 Removing Dishwasher Rack and basket 1:19 Removing Filter Parts 2:35 Washing Filter Parts 3:52 Replacing Filter Parts 5:06 Replacing Rack and basket 6:18 Cleaning common mold areas Download the user manual here: downloadcenter.samsung.com/content/UM/202312/20231219145639180/User_Manual_DW80N3030.pdf
How To Plug In Your USB Cable / Stick The Right Way Up First Time With This Trick
zhlédnutí 626Před rokem
No more fumbling trying one way then the other way. With this trick you can insert your USB cord the correctly polarized first time and every time. Instructions 1) Locate side of USB with Trident Logo 2) If No Logo locate Side with two Holes (Not the side with blocked Holes) 3) This means the 'Empty' part of the Plug is upwards 4) Locate the colored Plastic Tab in the USB Socket 5) Now Connect/...
How to Open / Close / Use an Isolation Valve (Service Valve)
zhlédnutí 16KPřed rokem
What Is An Isolation Valve? An isolation valve allows you to instantly cut off the water supply to a particular tap/faucet or washing machine so that you repair or replace the tap/faucet without having to shut down the water supply for the entire building. An isolation valve is a fitting within the plumbing pipework. They are also referred to as service valves. It can either allow water to flow...
How To Attach STIRRUP Pump Nozzle / Head to a SHRADER VALVE (The TRICK) LIFEHACK
zhlédnutí 93Před rokem
The Head needs to be pushed on sufficiently to depress the inner valve otherwise you will not be able to pump air in. The Rubber Nozzle / Head is rather tight so the trick is gently twist as you press see the the video
St Peter and St Paul Church Appleford with its Soaring Tower
zhlédnutí 77Před 2 lety
Appleford Church is a landmark for miles around. The tower and spire are visible from Wittenham Clumps and Sires Hill, from all the local roads and from the Oxford to Paddington railway and the Thames Footpath. St Peter and St Paul Church is open for visitors throughout the year. There are copies of the Parish Registers in the church for perusal. An informal ‘Family Breakfast Church’ takes plac...
How To Open VW Polo Bonnet / Hood 2017-onwards 6th Generation (Not Broken)
zhlédnutí 24KPřed 2 lety
#BONNET #HOOD Step 1) Locate Bonnet / Hood Release Lever inside RIGHT HAND SIDE door-well Step 2) Pull Door-Well SAFETY Lever to Release Bonnet / Hood to First Click (Enough to get your fingers underneath) Step 3) Move to the Front of the car Step 4) Locate the Under Bonnet/Hood Release Lever which is in the GAP above the VW Badge Step 5) The Lever is connected to the Car not the Bonnet so curl...
How To Open Mercedes E 320 BONNET / HOOD (NOT BROKEN)
zhlédnutí 29KPřed 2 lety
#BONNET #HOOD Step 1) Locate Bonnet / Hood Release Lever under Drivers Dashboard Step 2) Pull Door-Well SAFETY Lever to Release Bonnet / Hood to First Click (This Releases through bonnet T-Bar) Step 3) Move to the Front of the car Step 4) Locate the T-Bar Lever which above the Mercedes Logo Step 5) Pull T-Bar Lever and Lift Bonnet / Hood simultaneously with other hand To Close 1) CHECK you have...
How to Replace Broken Plastic Gear on Your Nutribullet (Remove Brass Nut)
zhlédnutí 17KPřed 2 lety
Before buying a replacement plastic gear disk make sure you can remove the brass nut. When the disk breaks it leaves behind the inner brass nut on the spindle. This nut is necessarily pretty tightly and in our case for over 5 years. lubricate the nut with WD40 it won't be enough but might make the job a little easier. Instructions:- Unplug the Nutribullet Unscrew the bottom cover. Try to undo t...
Unboxing Assembling & Inflating WattSUP Stand Up Paddle
zhlédnutí 1,4KPřed 2 lety
If possible assemble first in your garden/shed (practice) Remove all contents from the box CHECK ALL ITEMS INCLUDED PADDLE (2/3 sections) REPAIR KIT (ORANGE TUBE) FOOT SAFETY STRAP FIN WITH CLIP PUMP WITH SEPARATE FLEXIBLE PIPE INSTRUCTION BOOKLET INFLATABLE FOLDED SUP WITH STRAP (NOW TAKE A PHOTO OF EVERYTHING BEFORE UNWRAPPING) 1) Connect Pipe to the Pump (it's only a 3/4 turn) 2) Assemble Pa...
How To Zip Up A Backpack / Bag Without Snagging the Linings (Lifehack)
zhlédnutí 92Před 2 lety
Use Thumb & Adjacent fingers to Hold the Zip Pull Place remaining three fingers inside & underneath the zip. The two outer fingers deflect the inner flaps. After a few tries it becomes second nature. If the zip is stiff try lubrication with say a Silicon Lubricant.
How To Locate Ford Focus Spare Tyre & Jack & Repack Afterwards
zhlédnutí 25KPřed 2 lety
Spare (Emergency Tyre) under the boot floor. Lift and remove the Boot floor (not fixed) by getting fingers under an edge Undo the Bolt which has a handle that is retaining the Tyre. Store Bolt & Plastic Retaining Disk carefully Lift out the Emergency Wheel. The Jack & tools are now visible (Advice) Take a PHOTO of the tools so you easily put them back into the Plastic Holder You should have a J...
How To Open Tricky DS7 Crossback Bonnet / Hood (not broken) DS 7
zhlédnutí 7KPřed 2 lety
How To Open Tricky DS7 Crossback Bonnet / Hood (not broken) DS 7
How to Clean Siemens Washing Machine Filter (No tools required)
zhlédnutí 6KPřed 2 lety
How to Clean Siemens Washing Machine Filter (No tools required)
How To Disable Redmi Boot / Startup Sound / Audio . Step by Step Instructions. MIUI
zhlédnutí 2,4KPřed 2 lety
How To Disable Redmi Boot / Startup Sound / Audio . Step by Step Instructions. MIUI
How to Use A Bike Floor / Stirrup Pump to Inflate a Tyre / Tire
zhlédnutí 548Před 2 lety
How to Use A Bike Floor / Stirrup Pump to Inflate a Tyre / Tire
How to Open Volvo V60 Bonnet/Hood (Not Broken)
zhlédnutí 13KPřed 2 lety
How to Open Volvo V60 Bonnet/Hood (Not Broken)
How to Open Ford B Max Bonnet / Hood (not broken) bmax b-max
zhlédnutí 5KPřed 2 lety
How to Open Ford B Max Bonnet / Hood (not broken) bmax b-max
How To Open Ford Fiesta Bonnet / Hood MK6 2008-2017
zhlédnutí 50KPřed 2 lety
How To Open Ford Fiesta Bonnet / Hood MK6 2008-2017
How To Make a Cappuccino with a Tassimo | How to Insert Pods
zhlédnutí 15KPřed 2 lety
How To Make a Cappuccino with a Tassimo | How to Insert Pods
What does BAZBALL Mean? | The Winning Principles of BAZBALL
zhlédnutí 580Před 2 lety
What does BAZBALL Mean? | The Winning Principles of BAZBALL
How to Open Toyota Corolla Hybrid Bonnet / Hood (non-broken)
zhlédnutí 11KPřed 2 lety
How to Open Toyota Corolla Hybrid Bonnet / Hood (non-broken)
How To Disable Facebook Notification Beep on Your PC Browser : Step by Step Instructions
zhlédnutí 1,2KPřed 2 lety
How To Disable Facebook Notification Beep on Your PC Browser : Step by Step Instructions
How To Eliminate a Small Selfheal Lawn Infestation (Prunella Vulgaris)
zhlédnutí 1,1KPřed 2 lety
How To Eliminate a Small Selfheal Lawn Infestation (Prunella Vulgaris)
How To Remove Dried Birdshit / Bird Poop / Bird Lime from your Car
zhlédnutí 276Před 2 lety
How To Remove Dried Birdshit / Bird Poop / Bird Lime from your Car
How To Close Difficult Mercedes B200 Bonnet / Hood
zhlédnutí 2,8KPřed 2 lety
How To Close Difficult Mercedes B200 Bonnet / Hood
How To Choose a Reliable Non-Stick Wok Which will LAST
zhlédnutí 71Před 2 lety
How To Choose a Reliable Non-Stick Wok Which will LAST

Komentáře

  • @woodhose2475
    @woodhose2475 Před dnem

    What the fuck man? A rag like that can remove the stains without Baking soda too..

  • @Eightiesforever
    @Eightiesforever Před dnem

    Even though this video is 5 years old, it’s still helping people. It helped me today! Thanks!

  • @chrisparkin9947
    @chrisparkin9947 Před 3 dny

    Thanks! Another mystery solved. No instructions on the dispenser.

  • @JamesWright-g4u
    @JamesWright-g4u Před 3 dny

    Martin Michael Davis Lisa Gonzalez Anna

  • @cavannaro1
    @cavannaro1 Před 3 dny

    This alone would stop me from buying one of these cars.

  • @papiyagain5382
    @papiyagain5382 Před 3 dny

    Thank u ....its so helpful...

  • @JoelKoppel
    @JoelKoppel Před 5 dny

    You saved the day 🎉

  • @godlessfox7667
    @godlessfox7667 Před 5 dny

    Thank you!

  • @ADHSquad
    @ADHSquad Před 6 dny

    Thanku

  • @scottishalwaysdixie1638

    WTF. 🤡

  • @Lypno
    @Lypno Před 6 dny

    Thanks !!!

  • @villekoskela9073
    @villekoskela9073 Před 6 dny

    Tube diameter?

  • @nezukogk
    @nezukogk Před 9 dny

    Hey! I just got a Renault Laguna 2006. It has the same container for the coolant as yours. I find it quite difficult to read the min and max line of the coolant, as it is on the top and not on the side of the container as it usually is. Do you know how I should be filling it?

  • @nezukogk
    @nezukogk Před 10 dny

    Hey! I just got a Renault Laguna 2006. It has the exact same coolant jug as yours. I find it quite difficult to read the min and max line, as it is on the top and not on the side of the jug as it usually is. Do you know how I should be filling it?

  • @famouslyfabulous4819
    @famouslyfabulous4819 Před 11 dny

    Thanks so much you explained it great. Lisa

  • @PumaDiana888
    @PumaDiana888 Před 11 dny

    Thank you very much, your video helped me tremendously!!!!

  • @Buddy-nt6rd
    @Buddy-nt6rd Před 12 dny

    I’ve heard that set to become Abingdon‘s first mosque

  • @katiebugbu3
    @katiebugbu3 Před 13 dny

    Ty for saving me with into the pit

  • @enthusiast0
    @enthusiast0 Před 14 dny

    Soap strugglers - watch till the end of the video!!

  • @chrisgeller3058
    @chrisgeller3058 Před 14 dny

    Unfortunately the T lever on my vehicle is encased in a pouch in the grill. Has anyone else experienced this?

  • @AnneWoodford
    @AnneWoodford Před 15 dny

    Thankyou!

  • @jossyrodriguez3533
    @jossyrodriguez3533 Před 15 dny

    The fact that I have to google this video 😅whew!

  • @JulianneWillis-f8w
    @JulianneWillis-f8w Před 16 dny

    You just saved my life with this video, had milk leaking everywhere?? You solved the problem thank you thank you thank you! Brilliant

  • @pshekys
    @pshekys Před 17 dny

    Thanks mate, very straight to the point and informative

  • @jackieemmett6252
    @jackieemmett6252 Před 19 dny

    Thank you

  • @iaindooley9275
    @iaindooley9275 Před 19 dny

    Searched for Espresso Megamix ... nek minnit

  • @coreeceedwards5811
    @coreeceedwards5811 Před 21 dnem

    Very helpful, thanks for sharing

  • @petebarnard123
    @petebarnard123 Před 22 dny

    Thank you. I knew it had to be simple but my 'low IQ' would not let me work it out by myself 🙂

  • @Soseiquenadasei6474
    @Soseiquenadasei6474 Před 23 dny

    Qm ta aq pra pegar o spob no bear alpha?

  • @kazzarden70
    @kazzarden70 Před 25 dny

    Thanks for your short vid

  • @kamisbrbr
    @kamisbrbr Před 27 dny

    The bag 😂 worked Thanks

  • @juliuskim9717
    @juliuskim9717 Před 27 dny

    Thanks❤

  • @Caspian.
    @Caspian. Před 28 dny

    THANK YOU

  • @reggie1077
    @reggie1077 Před 29 dny

    I love that, very nice. ❤

  • @gregorymirabella1423
    @gregorymirabella1423 Před měsícem

    Thanks, I needed this for a minigame in FNAF: Into the Pit.

  • @_sheizer3173
    @_sheizer3173 Před měsícem

    How can I do on other side

  • @ryfe9197
    @ryfe9197 Před měsícem

    Another plot to drive us totally bonkers! LOL Thanks for saving my poor brain until the next onslaught!

  • @rocco37ful
    @rocco37ful Před měsícem

    donde se puede comprar esas barras portaequipajes de techo tengo el mismo modelo de vehiculo

  • @msosnow3
    @msosnow3 Před měsícem

    Thank you, I couldn't find how to remove this type of top spray arm and was worried about damaging it. You solved it. Thank you!

  • @KrishnaHRKichaKrishna
    @KrishnaHRKichaKrishna Před měsícem

    Thank you buddy

  • @jisharchatteysseri6877
    @jisharchatteysseri6877 Před měsícem

    Thank you soo much 😂

  • @mco3884
    @mco3884 Před měsícem

    ANTI-CLOCKWISE! That's been the secret the whole time lol

  • @Theknitnatchitchatshow
    @Theknitnatchitchatshow Před měsícem

    Really helpful thanks!

  • @steveloader2232
    @steveloader2232 Před měsícem

    I built that haha,,!

  • @steveloader2232
    @steveloader2232 Před měsícem

    I built that. Haha !😊

  • @steveloader2232
    @steveloader2232 Před měsícem

    I built that haha

  • @AvijitDas-ug5pw
    @AvijitDas-ug5pw Před měsícem

    Thanks

  • @richardpace9818
    @richardpace9818 Před měsícem

    Strange how we're pushed to think "microplastics,plastic,waste, pollution,problem,planet,etc....' and these clever machines are allowed to produce billions of small plastic waste pods probably every day, globally...It doesn't make sense to my simple reasoning.... Enjoy your cafe au lait though

  • @ilikefries99
    @ilikefries99 Před měsícem

    Very helpful thank you 👍

  • @Frutig3rAer0
    @Frutig3rAer0 Před měsícem

    Cool