Justin Orazio
Justin Orazio
  • 54
  • 192 441

Відео

Make Smartsheet Work For You - Automatically Change Cell Values For You
Переглядів 148Місяць тому
Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple Secret 3 Keys To Amazing Dashboards HERE: theescapeplanb.ck.page/1bd3d8d173 In this video you will walk away knowing how to have Smartsheet automatically do work for you by changing cell values when triggers hit - learn it for yourself!
Smartsheet Automations: Auto Assign Someone
Переглядів 1442 місяці тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple In this video you will learn how to create an automation workflow that will automatically assign someone when certain criteria is met - this helps especially when you have multiple tasks or projects going at once!
Smartsheet Automations: Create Automated Approval Process!
Переглядів 6252 місяці тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple In this video you will learn how to create an automated approval process inside your Smartsheet that will also automatically update the status and the people involved!
Smartsheet Automations: How To Create Automated Status Update Requests
Переглядів 4522 місяці тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple In this video you will learn how to create Status Updates Requests that will automatically be sent out based on a trigger!
Smartsheet Automations: How To Alert Someone Automatically
Переглядів 2262 місяці тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple In this quick video you will learn how to set up an automation that will alert someone in Smartsheet automatically.
How To Create Form Fields In Smartsheet
Переглядів 2043 місяці тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple In this training video you will learn how to create the different fields in a Smartsheet Form!
How To Find And Create Forms In Smartsheet!
Переглядів 2153 місяці тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple How To Create Forms: ua-cam.com/video/oX-Sl1XIvCA/v-deo.html This 5 min video shows you how to create and find your Forms in Smartsheet!
How To Insert Forms Into Dashboards and QR codes!
Переглядів 4313 місяці тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple How To Create Forms: ua-cam.com/video/oX-Sl1XIvCA/v-deo.html
How To Add Auto - Playing Videos On Dashboards
Переглядів 1734 місяці тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple Brandfolder info here: help.smartsheet.com/brandfolder Ever wonder how to add videos on your Smartsheet Dashboard that would just automatically play? Well in this video I will show you how! (You will need a Brandfolder license to do t...
GIF Videos In Smartsheet Forms!
Переглядів 2955 місяців тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple This video will teach you how to add GIF videos into your Smartsheet Forms!
How To Use The "IF" Formula In Smartsheet
Переглядів 1,1 тис.5 місяців тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple You will learn how to use the "IF" Formula correctly in Smartsheet! I will also show you an important scenario for when you need to use an "IF" Formula inside another "IF" formula.
New Feature in Smartsheet - Dashboard Themes!
Переглядів 2655 місяців тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple New Feature in Smartsheet - Dashboard Themes!
How To Use Smartsheet's AI tool!
Переглядів 1,6 тис.7 місяців тому
Top 32 Formulas in Smartsheet HERE: workflowmyworkload.ck.page/32formulas Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple How to use Smartsheet's already built in A.I. tool that will save you a ton of time!
Free LIVE Smartsheet Dashboard Training Tonight! Register in bio below!
Переглядів 49Рік тому
Free LIVE Smartsheet Dashboard Training Tonight! Register in bio below!
How To Use The 'AND' Formula in Smartsheet!
Переглядів 462Рік тому
How To Use The 'AND' Formula in Smartsheet!
Sheet Summary Secret - Do You Know About It?
Переглядів 1,8 тис.Рік тому
Sheet Summary Secret - Do You Know About It?
How To Create A Gantt Chart In Smartsheet From Scratch
Переглядів 6 тис.Рік тому
How To Create A Gantt Chart In Smartsheet From Scratch
How To Set Up Your Bid (Intake) Sheet The RIGHT Way!
Переглядів 583Рік тому
How To Set Up Your Bid (Intake) Sheet The RIGHT Way!
Smartsheet CONTAINS Formula - A Must Know Formula!
Переглядів 5 тис.Рік тому
Smartsheet CONTAINS Formula - A Must Know Formula!
Smartsheet Dashboard Updates That Will Make You Look More Professional
Переглядів 4,1 тис.Рік тому
Smartsheet Dashboard Updates That Will Make You Look More Professional
How To Use SUMIFS Formula Correctly in Smartsheet
Переглядів 3,4 тис.Рік тому
How To Use SUMIFS Formula Correctly in Smartsheet
Smartsheet + Construction DFR Forms
Переглядів 3,1 тис.Рік тому
Smartsheet Construction DFR Forms
How To Create Amazing Forms In Smartsheet
Переглядів 23 тис.Рік тому
How To Create Amazing Forms In Smartsheet
Game Changer Formula In Smartsheet
Переглядів 14 тис.Рік тому
Game Changer Formula In Smartsheet
How To Create Smartsheet Automations
Переглядів 8 тис.Рік тому
How To Create Smartsheet Automations
Basic Formulas In Smartsheet - How To Create Them
Переглядів 3,8 тис.Рік тому
Basic Formulas In Smartsheet - How To Create Them
How To Use Smartsheet Part #5 - Dashboards
Переглядів 1,1 тис.Рік тому
How To Use Smartsheet Part #5 - Dashboards
How To Use Smartsheet Part #4 - Reports
Переглядів 951Рік тому
How To Use Smartsheet Part #4 - Reports
How To Use Smartsheet Part #3
Переглядів 951Рік тому
How To Use Smartsheet Part #3

КОМЕНТАРІ

  • @shortsale
    @shortsale 6 днів тому

    awesome :) can you do a video on how to turn a form with a multi-select column, into an output of multiple rows with one multi-selected value per row, and duplicating the other data in the form?

  • @farrahcollins6807
    @farrahcollins6807 7 днів тому

    Such a good video.

  • @shaishaul-q7j
    @shaishaul-q7j 21 день тому

    There is an option to send the completed form to the sender in case he wants to update details so that it will update the same line and not open a new line

  • @nataliaramirez4358
    @nataliaramirez4358 Місяць тому

    Can you create a video of how to create formulas to divide cells and another one of how to multiply? I thought it worked like excel but it’s giving me errors.

  • @justjking15
    @justjking15 Місяць тому

    Hey Justin, i am really struggling to figure out how to calculate the total savings for a time period like a FY 06/30/23 to 06/30/24, can you help?

  • @suryakothapally1100
    @suryakothapally1100 Місяць тому

    Good information ! well Explained ! Thank you

  • @destineeorazio2206
    @destineeorazio2206 Місяць тому

    Looking forward to this live webinar!

  • @workflowmyworkload
    @workflowmyworkload Місяць тому

    Sign up HERE for the Smartsheet Dashboard Webinar that will be held on October 29th at 6:30pm CST: workflowmyworkload.ck.page/7d5d73712f

  • @SophornPhath-Sin
    @SophornPhath-Sin Місяць тому

    Hello, I already have column set up with numbers. When using forms they select that column and the number but it doesn’t populate to that line it goes on a new line instead. Is there a way to fix this?

    • @workflowmyworkload
      @workflowmyworkload Місяць тому

      Each form submission creates a new row. If the same row just kept getting updated it would erase the previous answer. If you are fine with that then instead of a form I would create a Status Update automation -here is a video I created to show you how to do just that: ua-cam.com/video/JOhYgFYEzZo/v-deo.html

  • @adariansearcy8301
    @adariansearcy8301 2 місяці тому

    Hi Justin, question: would it be easier to create three separate forms for three separate inspection visits for the same employee? - visit 1 (Date), field criteria - visit 2 (Date), same field criteria just associated with visit 2 - visit 3 (Date), same field criteria as visit 1 and 2 I would like the responses to live on one sheet. Thanks

    • @workflowmyworkload
      @workflowmyworkload Місяць тому

      Yes! You could definitely do that. Another option, if you’d rather have all 3 on one row, is to have visit 1 be a form, but visit 2 and 3 would be status updates on that row. Here is a video I made on Status Updates: ua-cam.com/video/JOhYgFYEzZo/v-deo.html

  • @KarenDelsman
    @KarenDelsman 2 місяці тому

    Your videos are so helpful! I have been struggling to figure out how to create a revise and approve loop using workflows. Essentially, I want the approver to keep seeing revision submissions until it is approval-worthy. Neither the submitter (via a form) nor the approver can access the sheet, just the emailed request screens. I, as sheet owner, would only be contacted once the row is approved. Parts of the automation are easy, but often I end up crashing the workflow with an infinite loop or multiple approval or revision requests happening simultaneously. HELP!

    • @workflowmyworkload
      @workflowmyworkload Місяць тому

      Can you send me a screen shot of your automation trees and send them to justin@workflowmyworkload.com ?

  • @lizbethjuveracardenas1855
    @lizbethjuveracardenas1855 2 місяці тому

    Hello thank you for all your guides, is there anyway I can create a form/ file to share to our collaborators so they can check their info?... for example if they introduce their employee ID; the the form/file can show them all their information (area, shift, manager) only as a viewer?

    • @workflowmyworkload
      @workflowmyworkload Місяць тому

      Yes! In the form, in the “helper text” in a field, you can actually add links. Create a Report with filter “current User” so anyone who logs in can only see what they are assigned to (aka their id number). Then take the URL link of that Report and paste it as a hyperlink in the form “helper text” field. I hope this helps!

    • @lizbethjuveracardenas1855
      @lizbethjuveracardenas1855 Місяць тому

      @@workflowmyworkload thank you!

  • @Amalappuwow
    @Amalappuwow 2 місяці тому

    Hi Justin your videos were really really helpful for me. I have a doubt, I Gantt view there is dotted line indicating Today (current day). Can we format that line to something like a bold line with colour, while making reports with Gantt view?

    • @workflowmyworkload
      @workflowmyworkload 2 місяці тому

      Hi! Smartsheet just came out with another view called "Timeline" that visualizes a more clean and more clear view than Gantt view. You will need to have a Business plan or Enterprise plan to view it and it is currently only for sheets not Reports. I believe in the future they will make it for Reports as well. Here is a Smartsheet article and video regarding Timeline: help.smartsheet.com/articles/2483056-timeline-view I hope this points you in the right direction! take care

  • @DeliaRojas-p5n
    @DeliaRojas-p5n 2 місяці тому

    How do I sign up?

    • @DeliaRojas-p5n
      @DeliaRojas-p5n 2 місяці тому

      Never mind. I didn't see the register link, lol.

  • @AbhishekKumar-pk5ej
    @AbhishekKumar-pk5ej 3 місяці тому

    Buddy do you have a solution for selecting drop down list in a coloumn of a sheet from a source sheet. Once the source sheet is updated the drop down in the destination sheet should also be updated. I was looking at Cheetah Apps but im sure it will come for an additional monthly subscription which I want to avoid. Any suggestion will be greatly appreciated.

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      Hey! there are 2 ways to go about this within Smartsheet, and they both require a Smartsheet premium app: Smartsheet DataShuttle or Smartsheet Bridge. Check with your existing Smartsheet plan to see if you already have one of these, and if so, I would start with Smartsheet DataShuttle. (Bridge is great but way more complex as it is their open API app). Have an excel sheet that houses your column(s) with the most up to date information, and then set up Smartsheet DataShuttle to have that excel sheet update automatically your Smartsheet column dropdown list. Here are links to DataShuttle and Bridge: DataShuttle Dropdown updating: help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle Bridge: help.smartsheet.com/articles/2482712-update-dropdown-columns

  • @AbhishekKumar-pk5ej
    @AbhishekKumar-pk5ej 3 місяці тому

    Im a brand new subscriber on your channel and I love your tutorial videos

  • @MackenzieVanderzanden
    @MackenzieVanderzanden 3 місяці тому

    I attempted the first formula you presented, but I am getting the error #UNPARSEABLE. I am not sure what I am doing wrong. my formula is this : =SUMIFS([Grand Total $]1:[Grand Total $]9),[Budget charged]1:[Budget charged]9, "Furniture"). I cant seem to get it to return any values, any advise?

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      Remove the “ ) ” after the “ [Grand Total $]9 “ in your formula and see if that does it - it shouldn’t be there, only at the end.

  • @priyankaawasthi9350
    @priyankaawasthi9350 3 місяці тому

    That's a great video, I'm trying to create scorecard in Smartsheet FORM can you help me with the formula

  • @JuanRuiz-pc7yu
    @JuanRuiz-pc7yu 3 місяці тому

    Wowww this is the best video how to do a smartsheet dashboard. Thanks.

  • @gudisevamsi
    @gudisevamsi 3 місяці тому

    #SmythsOS AI should leverage the strengths of Asana and Smartsheet to provide real-time project insights, predictive analytics, and intelligent recommendations, transforming project management into a proactive and data-driven process.

  • @nanadaimehokage1189
    @nanadaimehokage1189 3 місяці тому

    There is a way to change the data from one dropdownlist in base the selection of another one?

  • @BarbaraM-l5s
    @BarbaraM-l5s 3 місяці тому

    Love your teaching style. You explain the why behind what you are doing. Appreciate that.

  • @xxx-tf3fq
    @xxx-tf3fq 4 місяці тому

    Yay! I needed this! Thank you.

  • @Me11oIngenuity
    @Me11oIngenuity 5 місяців тому

    Great video. Dashboards seemed daunting to me. You made it less scary. Thank you.

  • @JaimeMarks-zh1nc
    @JaimeMarks-zh1nc 5 місяців тому

    Hey Justin! What is the benefit of using COLLECT over MATCH in the second example (referencing another sheet)?

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      COLLECT is good for grabbing data based on multiple criterions, MATCH is good for grabbing data based on just 1 criteria. I prefer COLLECT in most instances.

  • @MaheshNaik-b6p
    @MaheshNaik-b6p 5 місяців тому

    Hey Justin Thank you this was a very clear and informative vedio Could you please share the background music name?

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      I got it from Wondershare - its a platform used for editing videos. Here is there website: www.wondershare.net/?gad_source=1&gclid=Cj0KCQjwwae1BhC_ARIsAK4Jfrw_t_GZfNPZp28TOQ6T5HqePAHhMth1PQ42fcscCNCrWnS5zGcAycQaAgdhEALw_wcB

  • @ifeomagilberta7861
    @ifeomagilberta7861 5 місяців тому

    Can you please create something from scracth, I am new to this software and really struggling to understand. I just want to a video that has how to create a table from scratch and not imported.Thanks

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      Hi! here is another video I made where I created a sheet from scratch: ua-cam.com/video/6kJmo36mngk/v-deo.htmlsi=vyrO4KG0n6OmxclA

  • @ifeomagilberta7861
    @ifeomagilberta7861 5 місяців тому

    Great video! But I was hoping you will show how you created the table but you imported it instead.

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      Hi! Here is one of my videos where I make my sheet from scratch: ua-cam.com/video/wfO9ema_gk4/v-deo.htmlsi=GkTygIrbFLjGsVeT

    • @ifeomagilberta7861
      @ifeomagilberta7861 3 місяці тому

      @@workflowmyworkload Thank you!

  • @xzt1980
    @xzt1980 5 місяців тому

    very first formula didnt work for me, for some reason it just kept saying invalid operation :(

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      I know I am behind in responding, but if you paste the formula in I could take a look for you if you'd like.

  • @lisaleone2296
    @lisaleone2296 5 місяців тому

    I still say these forms, with field after field after field, are really NOT aesthetically pleasing and tend to be cumbersome for anything more than a simple survey.

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      Smartsheet has been making a lot of updates lately, and hopefully it will update form aesthetics.

  • @mpcinlv
    @mpcinlv 5 місяців тому

    Thank you .... again.

  • @karenasamuel8320
    @karenasamuel8320 5 місяців тому

    Is there a way, when creating a form and selecting it to be required with a number of characters. Can I not allow it to move to next field or get a box saying enter the correct number of characters?

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      You are not able to require number of characters but you can require on text field: Number only, Percentage, only, Email, only, phone number only, or No Validation

  • @miguelhidalgo9372
    @miguelhidalgo9372 5 місяців тому

    Justin! I love your course. The course is hot material! Everything is clearly explained! Thank you! Question: Do you address how to use Resource Allocation & Budgets?

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      Thank you so much! I would love to use your testimonial for the course, would that be ok with you? As far as for addressing resource allocation and budgets I could make a UA-cam video around that if you would like?

  • @anthonyolaleye
    @anthonyolaleye 6 місяців тому

    Thanks for the video Justin, I want to use the AI tool to setup an alert for upcoming due dates. I think this is already possible with the Automations section.

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      Yes! That can be accomplished with Smartsheet automations. Here is a video on that: ua-cam.com/video/P0dpsZp_nfQ/v-deo.html

  • @jodigriggs616
    @jodigriggs616 6 місяців тому

    Do you need to have a certain version of Smartsheet or license to use AI? I don't see the options of AI in my panel, and I don't have generate formula. Thx for any info you may have on this.

    • @workflowmyworkload
      @workflowmyworkload 3 місяці тому

      Yes! You would need Enterprise plan. Here is a link for more details: help.smartsheet.com/2483096/AI-Formulas-text-generator

  • @getmc
    @getmc 6 місяців тому

    Super-useful tips. Thanks!

  • @joycarpenters
    @joycarpenters 6 місяців тому

    hi, trying this formula to add the number of rooms booked in a day for a certain hotel but getting an error with the formula below example : =SUMIFS(=SUMIFS([20May]2:[20May]145, Hotel2:Hotel143, "Aloft") please note that the column of 20May contains value as a result of formula below =IF(AND($[Check-in]@row <= ([20May MON £00]$1), $[Check-out]@row > ([20May MON £00]$1)), 1, " ")

    • @workflowmyworkload
      @workflowmyworkload 6 місяців тому

      it could be because you have 2 "=SUMIFS(" back to back with each other. Also if you want could you email me a screen shot of the section of your Sheet where this formula lives? justin@workflowmyworkload.com

    • @workflowmyworkload
      @workflowmyworkload 6 місяців тому

      Also if your column "20May" is a Date column it will not add them. You would just need a "=COUNTIFS(" formula to count the Range "Hotel2:Hotel143" that contain "Aloft" in it.

  • @risheeshmishra8935
    @risheeshmishra8935 6 місяців тому

    This is the best Smartsheet Dashboard Tutorial so far on youtube. Really Helpful. Keep going brother.

  • @faynasser2168
    @faynasser2168 6 місяців тому

    How to add milestones into the Gantt chart?

    • @workflowmyworkload
      @workflowmyworkload 6 місяців тому

      Hi! I actually created a video specifically on milestones! Here it is: How to Create Milestones in a Gantt Chart in Smartsheet ua-cam.com/video/RoP2gj74kyY/v-deo.html

  • @faynasser2168
    @faynasser2168 6 місяців тому

    You are amazing!. Thank you so much.

  • @CasieMerritt-fj1wp
    @CasieMerritt-fj1wp 7 місяців тому

    Is there a way to reverse it. If checked then change column to different wording.... If checked (canceled) then change status column to Canceled

    • @workflowmyworkload
      @workflowmyworkload 7 місяців тому

      Yes absolutely! The formula then would live in the Status column and instead of using “1” and “0” you would use “Cancelled” and “other status”

  • @mpcinlv
    @mpcinlv 7 місяців тому

    Just got a Hostinger website for my first AI taste. Excited to see this post! Love Smartsheet. Thank you, again.

    • @workflowmyworkload
      @workflowmyworkload 7 місяців тому

      Awesome! I hope it helps save you time as you build out your sheets

  • @adariansearcy8301
    @adariansearcy8301 7 місяців тому

    Thanks Justin, you continuously drop great Smartsheet content. Appreciate it!

    • @workflowmyworkload
      @workflowmyworkload 7 місяців тому

      Absolutely! I hope everything is going well for you

  • @chiaradomenici1362
    @chiaradomenici1362 7 місяців тому

    Hi, great video! Can you pull data from two different sheets?

    • @workflowmyworkload
      @workflowmyworkload 7 місяців тому

      Hey! A graph can either be built off of 1 sheet, or 1 Report, but a Report can house multiple sheets. So if you are needing a graph to pull from multiple sheets I would have those sheets live in 1 Report and then build your graph off that Report. Or you could build out a metric sheet (which I prefer) that pulls in the data from 2+ other sheets through cross sheet formulas and then build your Graph off of that.

  • @miguelmoreno4025
    @miguelmoreno4025 7 місяців тому

    this should've been more a review of smart sheet rather than a comparison of the based on the bias.

    • @workflowmyworkload
      @workflowmyworkload 7 місяців тому

      I will admit I was leaning more towards Smartsheet simply because it’s a project management tool, which my career uses everyday. Excel is used more to hold large amounts of data which you can build pivots, tables, etc off of. Smartsheet is used for project management in spreadsheet form as well but also has the communication aspect and automations with it. Both tools have their place, it depends on what you really need it for.

  • @basaballg
    @basaballg 7 місяців тому

    How to increase the size of the text field to enter multiple comments

    • @workflowmyworkload
      @workflowmyworkload 7 місяців тому

      In the form edit mode, when you click on a text field, the panel on the right of your screen should have an option (about half way down) to choose “Multi text which will enlarge your text box on the form. You can then update the space number right below that option from 3 to a higher number to make the box even larger

  • @michaelzwingle2479
    @michaelzwingle2479 8 місяців тому

    Great video. Do you have a video on managing the database based on the submissions from the form you created?

  • @jamesdilio8979
    @jamesdilio8979 8 місяців тому

    Are you able to create a dynamic dashboard that will pull everything from Metric Sheet 123 so that we don't have to go in and edit the cells to include?

    • @workflowmyworkload
      @workflowmyworkload 8 місяців тому

      Yes if you build your Graph to pull from a Report instead of a metric sheet