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
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"
)
thank sir, very helpful
User | Count |
---|---|
28 | |
27 | |
22 | |
13 | |
6 |