Forum Discussion

KalvisT's avatar
KalvisT
Copper Contributor
Sep 29, 2021
Solved

Calculated column with IF formula

Hei,

 

I want to create a calculated column based on another value. Lets call this CalcColumn

so calccolumn =

If Column1 = Blank ---> blank 

If not blank then default value is 30

  • Hah, was simple enough and figured it out. =IF(ISBLANK([Column1], "", "30")

1 Reply

  • KalvisT's avatar
    KalvisT
    Copper Contributor
    Hah, was simple enough and figured it out. =IF(ISBLANK([Column1], "", "30")

Resources