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 for...
"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.
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.