Skip to main content
Topics#Reports & DashboardsQuestion de Lakshmi Akula
Lakshmi Akula (Culliganquench) a posé une question dans #Reports & Dashboards
14 janv. 2021, 16:33

I am trying to update a Activity field is null with task subtype as an Email using formula.

Hello Trailblazers,

 

Trying to use this formula BLANKVALUE

 

( ISPICKVAL( Activity_Type__c ,"")),'Email'). Error: Syntax error. Extra ','

 

Below is the screenshot for your reference. 

 

I cannot use Process builder and workflow because these custom fields are on Activity Object.I am trying to update a Activity field is null with task subtype as an Email using formula.

 

Thanks

 

Lakshmi
19 réponses
  1. Forum Ambassador Eric Praud (Activ8 Solar Energies)
    14 janv. 2021, 18:26
    Again, the value wouldn't show in Activity_Type. Now it's weird it says Email everywhere for the other values. 

     

    What if you try my very first formula with a small change ? 

    IF(ISBLANK( TEXT( Activity_Type__c )),'Email', TEXT (Activity_Type__c ))

     

     
Rédiger une réponse...
0/9000