Automate Status Based on Complete in Smartsheet Smartsheet Tutorial

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=BK2LlFOLE6M

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

#############################

New on site