Back to Browse

HOW TO add Status & Colour Indicators in Microsoft Project (Using IF Function)

2.9K views
Jan 11, 2024
7:12

In this Microsoft Project tutorial, Richard Walters teaches you how to create and insert status indicators to your project, using a Nested IF Function. This function is available in Microsoft Project when using Custom Field Calculations. In Microsoft Project, the "If" function, also known as the "IIf" function, is a powerful tool used in custom fields and formulas. It allows you to create conditional statements based on specified criteria. By utilising the IIf function, you can introduce flexibility and adaptability to your project management process, allowing for dynamic calculations and tailored views. #iffunction #msproject #projectmanagement ⌚TIMESTAMPS: 00:00 - Intro 00:48 - Nested IF Overview 01:58 - Writing the Nested IF Formula 04:40 - Inserting Graphical Indicators 05:27 - Testing Indicators 🎓 Our Microsoft Project Courses https://www.nilc.co.uk/category/office-applications/microsoft-office/project-training/ ➡️ Join this channel to get weekly video tutorials: https://www.youtube.com/channel/UCh337MvWCeVjBJyhXIsxt5A 🚩Let’s connect on social: Facebook: https://www.facebook.com/nilctraining Twitter: https://twitter.com/nilctraining LinkedIn: https://www.linkedin.com/company/nilctraining/ TikTok: https://www.tiktok.com/@nilctraining

Download

1 formats

Video Formats

360pmp411.4 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.