Automate Status Based on % Complete in Smartsheet | Smartsheet Tutorial скачать в хорошем качестве

Automate Status Based on % Complete in Smartsheet | Smartsheet Tutorial

In this video you will learn how to write a formula that automatically generates a status based on the % complete for a row. I'll show you how to do this using a nested IF Statement with data from one sheet or with multiple different sheets. 💻 FUNCTIONS USED ➣ IF() ➣ INDEX(MATCH()) 🏢 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 00:11 – Question from the Smartsheet Community 00:38 – Setting up the Nested If Statement on One Sheet 03:09 – Using the Color Circles Symbols to Represent Status 03:40 – Setting up the Nested If Statement using INDEX MATCH for Multiple Sheets 08:00 – Outro #smartsheet #formula #automation #projectmanagement #status