Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2022, 10:36 AM
Jairoriele Jairoriele is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2020
Posts: 4
Jairoriele is on a distinguished road
Default Fórmula MS Project

Guys, I'm trying to apply a simple formula in the project, but I'm not having success:
IIf([Status]="Late";"1";IIf([Status]="Completed";"2";IIf([Status]="Due";"3";"4")))
It always accuses 4, as if it doesn't recognize the statuses. can anybody help me?
Reply With Quote
  #2  
Old 02-05-2022, 03:13 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

Status field in formula is a number. So your formula always returns 4 because all the other conditions are wrong.

See screenshots below for simpler solution.





But if you want to use your own numbers for Status (which I won't recommend), then use the formula below

IIf([Status]=2,1,IIf([Status]=0,2,IIf([Status]=1,3,4)))

Planners' Place
Reply With Quote
Reply

Tags
formula, status

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graphical indicator formula for MS Project Quinn87 Project 2 03-28-2021 11:38 PM
MS Project - RAG status formula imzkhan4 Project 0 11-13-2018 12:25 PM
Formula for cum work in Project 2003 pwhill Project 5 11-09-2014 03:22 PM
Formula To Calculate Countdown Days To Project Completion Catherine Project 1 02-19-2014 11:15 AM
Implementing excel formula in project nawab35 Project 6 08-04-2011 05:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft