Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago
Solved

Project Progress Status

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

Need Help
  • foodd's avatar
    foodd
    2 years ago

    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.

3 Replies

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    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.

      • foodd's avatar
        foodd
        Community Champion
        2 years ago

        Your welcome. 

         

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