Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

IF Function & Filter Help

The Goal is to have one column that generates "SDR Gen" is the SRD Name and AE Name are not blank, and generate "Self Gen" if the SDR name is blank and the AE Name is not blank. Here are the two formulas I have tried, any tips?

SDR Gen = (IF(Opportunity[SDR Name]<> BLANK() && Opportunity[AE Name]<>BLANK(), "SDR Gen"), IF(Opportunity[SDR Name]= BLANK() & Opportunity[AE Name]<> BLANK(), "Self Gen", BLANK()))

SDR Gen = (IF(Opportunity[SDR Name]<> BLANK(), "SDR Gen", "Self Gen"), FILTER(Opportunity, Opportunity[AE Name]<> BLANK()))

Any suggestions on how to make this work would be greatly appreciated.


"FILTER"
"if statement"
Formula with Multiple Conditions
if
  • Irwan's avatar
    Irwan
    2 years ago

    hello Anonymous ,

     

    please check if this accomodate your need.

    SDR Gen =
    IF(
        not ISBLANK('Table'[SRD Name])&&not ISBLANK('Table'[AE Name]),
        "SDR Gen",
    IF(
        ISBLANK('Table'[SRD Name])&&not ISBLANK('Table'[AE Name]),
        "Self Gen",
        BLANK()
    ))
     
    Hope this will help you.
    Thank you.

1 Reply

  • Irwan's avatar
    Irwan
    Super User
    2 years ago

    hello Anonymous ,

     

    please check if this accomodate your need.

    SDR Gen =
    IF(
        not ISBLANK('Table'[SRD Name])&&not ISBLANK('Table'[AE Name]),
        "SDR Gen",
    IF(
        ISBLANK('Table'[SRD Name])&&not ISBLANK('Table'[AE Name]),
        "Self Gen",
        BLANK()
    ))
     
    Hope this will help you.
    Thank you.