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 schoolofsheets.com
🤝 WANT TO WORK WITH US?
Fill out our new client interest form at schoolofsheets.com/WorkWithUs
📚 KEY RESOURCES
➔ Try Smartsheet free for 30-days schoolofsheets.com/TrySmartsheetFree
🔔 SUBSCRIBE FOR MORE GREAT CONTENT
👉 youtube.com/@SchoolofSheets?sub_confirmation=1
⌚ 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
- Automate Status Based on % Complete in Smartsheet | Smartsheet Tutorial ( Download)
- Calculating Project Level Percent Complete in Smartsheet | Smartsheet Tutorial ( Download)
- Record Dates Based on Status Changes with Smartsheet Automations | Smartsheet Tutorial ( Download)
- How To Use SmartSheet | SmartSheet Tutorial For Project Management (2024) ( Download)
- Creating an Automatic Document Generation Workflow in Smartsheet | Smartsheet Tutorial ( Download)
- How to use Reports in Smartsheet ( Download)
- Populating a Date Field Based on Status Change in Smartsheet | Smartsheet Tutorial ( Download)
- Smartsheet IF Formulas - How To Build Them & Best Practices ( Download)
- How to use Formulas in Smartsheet ( Download)
- Automated Workflows Overview ( Download)
- Smartsheet Automated Workflow Tutorial 2024 | Build & Automate Workflows ( Download)
- Smartsheets Requesting Updates Automation Tutorial Project Management ( Download)
- How To Insert Checkbox In Smartsheet [Smartsheet Training] ( Download)
- Using a Nested IF OR Statement in Smartsheet Returning a Region by State | Smartsheet Tutorial ( Download)
- How to Use Smartsheet Charts ( Download)
