Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyProject 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 i...
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.
AllanBercesPost Prodigy
Post ProdigyHi foodd Thank you very much, working perfectly
foodd
Community Champion
Community ChampionYour welcome.
If the solution provided is of interest, consider adding Kudos.