Team,
I want to Count the total number of Pending tasks of a user, it is working fine.
But when we want if Zone is bank then count Pending task of user else count pending task which is equal to zone is not working.
Working Formula: COUNTA( LOOKUP([Asset_Visit_Status.Status] , AND( Asset_Visit_Status.Sale_Coordinator = USEREMAIL , Asset_Visit_Status.Status = “Pending” , Asset_Visit_Status.Created_At >= from , Asset_Visit_Status.Created_At <= to)))
Not Working Formula: IF( ISBLANK( zone) , COUNTA( LOOKUP([Asset_Visit_Status.Status] , AND( Asset_Visit_Status.Sale_Coordinator = USEREMAIL , Asset_Visit_Status.Status = “Pending” , Asset_Visit_Status.Created_At >= from , Asset_Visit_Status.Created_At <= to) , COUNTA( LOOKUP([Asset_Visit_Status.Status] , AND( Asset_Visit_Status.ADM_Zone = zone , Asset_Visit_Status.Status = “Pending” , Asset_Visit_Status.Created_At >= from , Asset_Visit_Status.Created_At <= to))))))