Using a Nested IF OR Statement in Smartsheet Returning a Region by State | Smartsheet Tutorial скачать в хорошем качестве

Using a Nested IF OR Statement in Smartsheet Returning a Region by State | Smartsheet Tutorial

In this video, Dan from School of Sheets answers a question from the Smartsheet Community about IF OR Statements. A user is trying to make a formula that will evaluate a State in a cell and return the region that State belongs to. Watch as we create the entire sheet and formula from the ground up. 🏢 ABOUT SCHOOL OF SHEETS ➔ We are a bespoke consulting firm specializing in developing custom Smartsheet Solutions ➔ We are a Smartsheet Aligned Gold partner with a team of certified consultants and software developers. ➔ We work with businesses of all sizes and industries. ➔ Learn more at http://www.schoolofsheets.com 🤝 WANT TO WORK WITH US? Fill out our new client interest form at https://www.schoolofsheets.com/WorkWi... 📚 KEY RESOURCES ➔ Try Smartsheet free for 30-days http://www.schoolofsheets.com/TrySmar... 🔔 SUBSCRIBE FOR MORE GREAT CONTENT 👉    / @schoolofsheets   ⌚ TIMESTAMPS 00:00 – Intro and Info about the Smartsheet Community Thread 00:33 – Introducing the User's Question 00:55 – Setting up the Example Sheet 01:53 – Testing Out the Current "Unparseable" Formula 02:50 – Re-Building the Formula with Individual IF Statements 04:40 – Re-Building the Formula with IF OR Statements 06:33 – Posting the Solution to the Community Thread 07:10 – Outro #smartsheet #formula #ifstatement #tutorial