SOLVED

Calculated column with IF formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2794111%22%20slang%3D%22en-US%22%3ECalculated%20column%20with%20IF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2794111%22%20slang%3D%22en-US%22%3E%3CP%3EHei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20calculated%20column%20based%20on%20another%20value.%20Lets%20call%20this%20CalcColumn%3C%2FP%3E%3CP%3Eso%20calccolumn%20%3D%3C%2FP%3E%3CP%3EIf%20Column1%20%3D%20Blank%20---%26gt%3B%20blank%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20not%20blank%20then%20default%20value%20is%2030%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2794111%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

1 Reply
best response confirmed by KalvisT (New Contributor)
Solution
Hah, was simple enough and figured it out. =IF(ISBLANK([Column1], "", "30")