SP List - Change status column to complete if another column has a value

%3CLINGO-SUB%20id%3D%22lingo-sub-1152649%22%20slang%3D%22en-US%22%3ESP%20List%20-%20Change%20status%20column%20to%20complete%20if%20another%20column%20has%20a%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1152649%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20have%20SharePoint%20list%20with%20a%20calculated%20column%20called%20status%20and%20I%20want%20it%20to%20show%20Open%20if%20another%20column%20doesn't%20have%20a%20completion%20date%20in%20(blank%20value)%20and%20Closed%20if%20it%20has%20a%20date%20in.%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20with%20the%20formula%20I%20need%20to%20enter%20into%20the%20calculated%20status%20column%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3EAndrea%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1152649%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi

I have SharePoint list with a calculated column called status and I want it to show Open if another column doesn't have a completion date in (blank value) and Closed if it has a date in.

Can anyone help me with the formula I need to enter into the calculated status column please?

 

thanks

Andrea 

0 Replies