IF ISNOTBLANK SELECT

[intern_pe]

Hello please help me for this expression that confuse me

IF(ISNOTBLANK(SELECT(Analyze[Analyze ID],[Issue ID]=[_THISROW].[Issue ID] )),"Analyzed","Waiting for Action")
& IF(ISNOTBLANK(SELECT(Task[Task ID],[Issue ID]=[_THISROW].[Issue ID] )),"In Progress","Analyzed")

how to combine this two expression and to choose one result from it

[Richard_Fages1]

Hi @intern_pe , maybe this formula is appropriate.

IFS(
  ISNOTBLANK(SELECT(Task[Task ID],[Issue ID]=[_THISROW].[Issue ID])),
  "In Progress",
  ISNOTBLANK(SELECT(Analyze[Analyze ID],[Issue ID]=[_THISROW].[Issue ID])),
  "Analyzed",
  AND(
    ISBLANK(SELECT(Task[Task ID],[Issue ID]=[_THISROW].[Issue ID])),
    ISBLANK(SELECT(Analyze[Analyze ID],[Issue ID]=[_THISROW].[Issue ID]))
  ),
  "Waiting for Action"
)

[intern_pe]

thank sir, very helpful