Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
3 years ago
Solved

Condtional calculated column

Hi i have 4 columns A,B,C,D I  need to create new column E That  should be the Combination of C&D  So E = C&D and one more condition is there if C Column doesn't have any data, if it is bl...
Need Help
Show and Tell
Tips and Tricks
  • Ajith_Kumar's avatar
    Ajith_Kumar
    3 years ago

    Hi AlanP514 ,

    I hope the below image helpful for your query,


    Thanks,
    Ajith_Kumar

    If I answered your question then mark my post as a solution and a kudo would be appreciated.

Ahmedx's avatar
Ahmedx
Super User
3 years ago

 

if (ISBLANK([C]),[B], [C]&[D])

OR
if (ISBLANK([C]),[B]&[D], [C]&[D])