Forum Discussion

gaby58's avatar
gaby58
Frequent Visitor
1 year ago

Multiple If with Multiple Conditions

Hi All,     Need help in creating a Custom Column. I have 2 columns and need to check values in first column, based on that I need to check values in another column, this one has multiple values, d...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago
Column = IF([Section Stage] IN {"Complete","In Progress"},
    SWITCH(TRUE(),
    [DateLeft_Adjusted] IN {"12/20/2024","10/11/2024"},"01/07/2025",
    [DateLeft_Adjusted] IN {"3/7/2025","5/22/2025"},"6/5/2025",
    [DateLeft_Adjusted]+1),
[DateLeft_Adjusted]+1)
gaby58's avatar
gaby58
Frequent Visitor
1 year ago

Thank you , but it is throwing an error at Complete saying Token ',' expected

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    "Column" is a reserved word.  Try

     

    Column1 =
IF (
    [Section Stage] IN { "Complete", "In Progress" },
    SWITCH (
        TRUE (),
        [DateLeft_Adjusted] IN { "12/20/2024", "10/11/2024" }, "01/07/2025",
        [DateLeft_Adjusted] IN { "3/7/2025", "5/22/2025" }, "6/5/2025",
        [DateLeft_Adjusted] + 1
    ),
    [DateLeft_Adjusted] + 1
)