- 54
- 192 441
Justin Orazio
United States
Приєднався 17 жов 2014
I create management systems within Smartsheet on a daily basis for multiple companies and have done so for over 4 years now. I am product certified in Smartsheet. I have created management workflows from the ground up for multiple different companies and organizations all through Smartsheet. I love to see others grow and progress in new skills and will guide you every step of the way to ensure you reach your goal.
Live Smartsheet Dashboard Training Nov 5th 6:30pm CST
Watch the Recorded Training Video Here: ua-cam.com/video/elOGwGgncJw/v-deo.html
Переглядів: 37
Відео
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
How To Create Amazing Forms In Smartsheet
Переглядів 23 тис.Рік тому
How To Create Amazing Forms In Smartsheet
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
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?
Such a good video.
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
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.
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?
Good information ! well Explained ! Thank you
Your welcome!
Looking forward to this live webinar!
Sign up HERE for the Smartsheet Dashboard Webinar that will be held on October 29th at 6:30pm CST: workflowmyworkload.ck.page/7d5d73712f
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?
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
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
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
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!
Can you send me a screen shot of your automation trees and send them to justin@workflowmyworkload.com ?
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?
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!
@@workflowmyworkload thank you!
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?
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
How do I sign up?
Never mind. I didn't see the register link, lol.
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.
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
Im a brand new subscriber on your channel and I love your tutorial videos
Thanks for subbing!
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?
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.
That's a great video, I'm trying to create scorecard in Smartsheet FORM can you help me with the formula
Wowww this is the best video how to do a smartsheet dashboard. Thanks.
Absolutely! I'm glad it was helpful
#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.
There is a way to change the data from one dropdownlist in base the selection of another one?
Love your teaching style. You explain the why behind what you are doing. Appreciate that.
My pleasure!
Yay! I needed this! Thank you.
Great video. Dashboards seemed daunting to me. You made it less scary. Thank you.
You're welcome!
Hey Justin! What is the benefit of using COLLECT over MATCH in the second example (referencing another sheet)?
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.
Hey Justin Thank you this was a very clear and informative vedio Could you please share the background music name?
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
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
Hi! here is another video I made where I created a sheet from scratch: ua-cam.com/video/6kJmo36mngk/v-deo.htmlsi=vyrO4KG0n6OmxclA
Great video! But I was hoping you will show how you created the table but you imported it instead.
Hi! Here is one of my videos where I make my sheet from scratch: ua-cam.com/video/wfO9ema_gk4/v-deo.htmlsi=GkTygIrbFLjGsVeT
@@workflowmyworkload Thank you!
very first formula didnt work for me, for some reason it just kept saying invalid operation :(
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.
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.
Smartsheet has been making a lot of updates lately, and hopefully it will update form aesthetics.
Thank you .... again.
My pleasure!
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?
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
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?
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?
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.
Yes! That can be accomplished with Smartsheet automations. Here is a video on that: ua-cam.com/video/P0dpsZp_nfQ/v-deo.html
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.
Yes! You would need Enterprise plan. Here is a link for more details: help.smartsheet.com/2483096/AI-Formulas-text-generator
Super-useful tips. Thanks!
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, " ")
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
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.
This is the best Smartsheet Dashboard Tutorial so far on youtube. Really Helpful. Keep going brother.
How to add milestones into the Gantt chart?
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
You are amazing!. Thank you so much.
Is there a way to reverse it. If checked then change column to different wording.... If checked (canceled) then change status column to Canceled
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”
Just got a Hostinger website for my first AI taste. Excited to see this post! Love Smartsheet. Thank you, again.
Awesome! I hope it helps save you time as you build out your sheets
Thanks Justin, you continuously drop great Smartsheet content. Appreciate it!
Absolutely! I hope everything is going well for you
Hi, great video! Can you pull data from two different sheets?
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.
this should've been more a review of smart sheet rather than a comparison of the based on the bias.
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.
How to increase the size of the text field to enter multiple comments
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
Great video. Do you have a video on managing the database based on the submissions from the form you created?
Not yet but I definitely can!
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?
Yes if you build your Graph to pull from a Report instead of a metric sheet