Project Progress Status

[AllanBerces]

Hi Experts,

Good day

Can anyone pls need assistance on how can i change the Project Completed column status in new column. 

If the Project Completed is 100 = Completed 
if the Project Completed is  greaterthan 0 but lessthan 100 = In-Progress
if the Project Completed is blank or 0 = Not started

Thank you

[foodd · Accepted solution]

You can create a custom column using the SWITCH function as follows:

Status Custom Column = SWITCH(
    TRUE(),
    [Project Completed] = 100, "Completed",
    [Project Completed] > 0 && [Project Completed] < 100, "In-Progress",
    ISBLANK([Project Completed]) || [Project Completed] = 0, "Not started"
)

=-=-=-=-=-

If you find this insightful, please provide a Kudo and accept this as a solution so that other members may find it easier.

[AllanBerces]

Hi @foodd Thank you very much, working perfectly

[foodd]

Your welcome. 

If the solution provided is of interest, consider adding Kudos.