Solved: Re: Custom Column Help

S_M_ · ‎02-14-2022

Hi,

Please help me with what am I missing here in the formula.

Appreciate any help!

AlexisOlson · ‎02-14-2022

M is case-sensitive and doesn't use END.

Try this (assuming your column names have the correct case):

if [Project Status] = "Completed" and [COMPLETION_DATE] <> ""
then [COMPLETION_DATE]
else [CONTRACT_PENDING_DATE]

AlexisOlson · ‎02-14-2022

M is case-sensitive and doesn't use END.

Try this (assuming your column names have the correct case):

if [Project Status] = "Completed" and [COMPLETION_DATE] <> ""
then [COMPLETION_DATE]
else [CONTRACT_PENDING_DATE]

Custom Column Help