Skip to Content
0
Former Member
Feb 17, 2015 at 01:22 PM

Formula for finding project status!!

14 Views

Hi all,

I need help for formula to get the status of a project looking at project_id and task status , if all the task_status of a particular project is done then the status should be Done for that particular project ID.

How to create a crystal formula?

the scenario is

Project_ID Task_Name Task_Status 10 abc Inprogress 10 xyz Done 10 lmn Inprogress 20 qwe Done 20 asd Done 30 tyr Inprogress 30 ghj Done 30 ert Done