Forum Discussion

anabianco09's avatar
anabianco09
Icon for Helper II rankHelper II
2 years ago
Solved

Error when creating a CUSTOM COLUMN

Hi, I am trying to create the following column:

and it shows up an error message that the name IF wasn't recognized. How to Solve?

  • Please refer the screenshot and modify your formula, it will worksπŸ‘Kindly mark my post as solution, Appreciate your Kudos .

    if [Condition1] = "Value1" and [Condition2] = "Value2" then "Result1"
    else "Result2"

     

     

     

3 Replies

  • SumitChandra's avatar
    SumitChandra
    Frequent Visitor

    Please refer the screenshot and modify your formula, it will worksπŸ‘Kindly mark my post as solution, Appreciate your Kudos .

    if [Condition1] = "Value1" and [Condition2] = "Value2" then "Result1"
    else "Result2"

     

     

     

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar

    Hi,

     

    try a lower case if

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos πŸ‘