Justin Orazio
Justin Orazio
  • Видео 52
  • Просмотров 175 421
Make Smartsheet Work For You - Automatically Change Cell Values For You
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!
Просмотров: 40

Видео

Smartsheet Automations: Auto Assign Someone
Просмотров 6521 день назад
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!
Просмотров 19028 дней назад
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
Просмотров 166Месяц назад
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
Просмотров 103Месяц назад
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
Просмотров 87Месяц назад
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!
Просмотров 77Месяц назад
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: ruclips.net/video/oX-Sl1XIvCA/видео.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!
Просмотров 254Месяц назад
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: ruclips.net/video/oX-Sl1XIvCA/видео.html
How To Add Auto - Playing Videos On Dashboards
Просмотров 1182 месяца назад
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!
Просмотров 2383 месяца назад
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
Просмотров 6423 месяца назад
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!
Просмотров 2224 месяца назад
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,2 тыс.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 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!
Просмотров 4911 месяцев назад
Register Here: us06web.zoom.us/meeting/register/tZAlfuCqpzwiH9P2oRSswd0JWTkn8Jfy5aKs
How To Use The 'AND' Formula in Smartsheet!
Просмотров 35811 месяцев назад
Register For Live Training: us06web.zoom.us/meeting/register/tZAlfuCqpzwiH9P2oRSswd0JWTkn8Jfy5aKs Top 32 Function Free Guide: workflowmyworkload.ck.page/ce85816a8c Access Entire Course HERE: justin-orazio-s-school.teachable.com/p/smartsheet-made-simple TikTok: www.tiktok.com/@workflow_my_workload?_t=8frEteazMdz&_r=1
Sheet Summary Secret - Do You Know About It?
Просмотров 1,6 тыс.11 месяцев назад
Sheet Summary Secret - Do You Know About It?
How To Create A Gantt Chart In Smartsheet From Scratch
Просмотров 5 тыс.Год назад
How To Create A Gantt Chart In Smartsheet From Scratch
How To Set Up Your Bid (Intake) Sheet The RIGHT Way!
Просмотров 500Год назад
How To Set Up Your Bid (Intake) Sheet The RIGHT Way!
Smartsheet CONTAINS Formula - A Must Know Formula!
Просмотров 4,9 тыс.Год назад
Smartsheet CONTAINS Formula - A Must Know Formula!
Smartsheet Dashboard Updates That Will Make You Look More Professional
Просмотров 3,8 тыс.Год назад
Smartsheet Dashboard Updates That Will Make You Look More Professional
How To Use SUMIFS Formula Correctly in Smartsheet
Просмотров 3 тыс.Год назад
How To Use SUMIFS Formula Correctly in Smartsheet
Smartsheet + Construction DFR Forms
Просмотров 2,7 тыс.Год назад
Smartsheet Construction DFR Forms
How To Create Amazing Forms In Smartsheet
Просмотров 21 тыс.Год назад
How To Create Amazing Forms In Smartsheet
Game Changer Formula In Smartsheet
Просмотров 13 тыс.Год назад
Game Changer Formula In Smartsheet
How To Create Smartsheet Automations
Просмотров 7 тыс.Год назад
How To Create Smartsheet Automations
Basic Formulas In Smartsheet - How To Create Them
Просмотров 3,5 тыс.Год назад
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
Просмотров 906Год назад
How To Use Smartsheet Part #4 - Reports
How To Use Smartsheet Part #3
Просмотров 930Год назад
How To Use Smartsheet Part #3
How To Use Smartsheet Part #2
Просмотров 1,4 тыс.Год назад
How To Use Smartsheet Part #2

Комментарии

  • @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?

  • @adariansearcy8301
    @adariansearcy8301 4 дня назад

    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

  • @KarenDelsman
    @KarenDelsman 8 дней назад

    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!

  • @lizbethjuveracardenas1855
    @lizbethjuveracardenas1855 24 дня назад

    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?

  • @Amalappuwow
    @Amalappuwow Месяц назад

    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 Месяц назад

      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 Месяц назад

    How do I sign up?

    • @DeliaRojas-p5n
      @DeliaRojas-p5n Месяц назад

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

  • @AbhishekKumar-pk5ej
    @AbhishekKumar-pk5ej Месяц назад

    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 Месяц назад

      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 Месяц назад

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

  • @MackenzieVanderzanden
    @MackenzieVanderzanden Месяц назад

    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 Месяц назад

      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 Месяц назад

    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 Месяц назад

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

  • @gudisevamsi
    @gudisevamsi Месяц назад

    #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 Месяц назад

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

  • @BarbaraM-l5s
    @BarbaraM-l5s 2 месяца назад

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

  • @xxx-tf3fq
    @xxx-tf3fq 2 месяца назад

    Yay! I needed this! Thank you.

  • @Me11oIngenuity
    @Me11oIngenuity 3 месяца назад

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

  • @JaimeMarks-zh1nc
    @JaimeMarks-zh1nc 3 месяца назад

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

    • @workflowmyworkload
      @workflowmyworkload Месяц назад

      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 3 месяца назад

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

    • @workflowmyworkload
      @workflowmyworkload Месяц назад

      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 3 месяца назад

    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 Месяц назад

      Hi! here is another video I made where I created a sheet from scratch: ruclips.net/video/6kJmo36mngk/видео.htmlsi=vyrO4KG0n6OmxclA

  • @ifeomagilberta7861
    @ifeomagilberta7861 3 месяца назад

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

    • @workflowmyworkload
      @workflowmyworkload Месяц назад

      Hi! Here is one of my videos where I make my sheet from scratch: ruclips.net/video/wfO9ema_gk4/видео.htmlsi=GkTygIrbFLjGsVeT

    • @ifeomagilberta7861
      @ifeomagilberta7861 Месяц назад

      @@workflowmyworkload Thank you!

  • @xzt1980
    @xzt1980 3 месяца назад

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

    • @workflowmyworkload
      @workflowmyworkload Месяц назад

      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 3 месяца назад

    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 Месяц назад

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

  • @mpcinlv
    @mpcinlv 3 месяца назад

    Thank you .... again.

  • @karenasamuel8320
    @karenasamuel8320 4 месяца назад

    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 Месяц назад

      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 4 месяца назад

    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 Месяц назад

      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 RUclips video around that if you would like?

  • @anthonyolaleye
    @anthonyolaleye 4 месяца назад

    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 Месяц назад

      Yes! That can be accomplished with Smartsheet automations. Here is a video on that: ruclips.net/video/P0dpsZp_nfQ/видео.html

  • @jodigriggs616
    @jodigriggs616 4 месяца назад

    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 Месяц назад

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

  • @getmc
    @getmc 4 месяца назад

    Super-useful tips. Thanks!

  • @joycarpenters
    @joycarpenters 4 месяца назад

    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 4 месяца назад

      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 4 месяца назад

      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 4 месяца назад

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

  • @faynasser2168
    @faynasser2168 4 месяца назад

    How to add milestones into the Gantt chart?

    • @workflowmyworkload
      @workflowmyworkload 4 месяца назад

      Hi! I actually created a video specifically on milestones! Here it is: How to Create Milestones in a Gantt Chart in Smartsheet ruclips.net/video/RoP2gj74kyY/видео.html

  • @faynasser2168
    @faynasser2168 4 месяца назад

    You are amazing!. Thank you so much.

  • @CasieMerritt-fj1wp
    @CasieMerritt-fj1wp 5 месяцев назад

    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 5 месяцев назад

      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 5 месяцев назад

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

    • @workflowmyworkload
      @workflowmyworkload 5 месяцев назад

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

  • @adariansearcy8301
    @adariansearcy8301 5 месяцев назад

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

    • @workflowmyworkload
      @workflowmyworkload 5 месяцев назад

      Absolutely! I hope everything is going well for you

  • @chiaradomenici1362
    @chiaradomenici1362 5 месяцев назад

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

    • @workflowmyworkload
      @workflowmyworkload 5 месяцев назад

      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 5 месяцев назад

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

    • @workflowmyworkload
      @workflowmyworkload 5 месяцев назад

      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 6 месяцев назад

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

    • @workflowmyworkload
      @workflowmyworkload 5 месяцев назад

      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 6 месяцев назад

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

  • @jamesdilio8979
    @jamesdilio8979 6 месяцев назад

    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 6 месяцев назад

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

  • @farrahcollins6807
    @farrahcollins6807 6 месяцев назад

    This was fantastic and simple. I always feel like I learn something useful when watching you.

  • @sharonounapuu6463
    @sharonounapuu6463 6 месяцев назад

    Awesome tutorial. Thanks!

  • @ReneeTozzi
    @ReneeTozzi 6 месяцев назад

    I find your videos very helpful!

  • @shawnw.4440
    @shawnw.4440 7 месяцев назад

    When searching to learn something new I try to go first to channels without many subscribers to give them a boost. Once you got to the content it was helpful. I'd advise, however, that 1 1/2 minutes of intro (inclduing repetitive intro telling us multiple times the contains formula will be use but not telling us what it's useful for) is too long. Almost 4 minutes in before telling us what contains formula does or can be used for. Would have engaged me better if you'd opened with 'contains formula is really useful because it can do this and that, or this and that. I'm going to show you a 'beginner's example and a more powerful nested example that will spark your creativity how you can use it to save you time' - 30 seconds. Bam!

    • @workflowmyworkload
      @workflowmyworkload 7 месяцев назад

      Thank you for the feedback I will definitely keep that in mind

  • @dyannejglass
    @dyannejglass 7 месяцев назад

    Great info, but need to cut back on so much talking and promoting. Give the intro 5 minutes before it actually starts. Thank you for all of the time you put into this. THUMBS UP!