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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Write it like

 

if ([Section Stage]="Complete"or [Section Stage]="In Progress") and ([DateLeft_Adjusted]="12/20/2024" or [DateLeft_Adjusted]= "10/11/2024") then "01/07/2025" else if ([DateLeft_Adjusted] = "3/7/2025" or [DateLeft_Adjusted] = "5/22/2025") then "6/5/2025"

else

Text.From([DateLeft_Adjusted]+1)

gaby58's avatar
gaby58
Frequent Visitor
1 year ago

Thank you, this kind of works, then in the column it throws an error

Expression.Error: We cannot apply operator + to types Date and Number.
Details:
Operator=+
Left=12/20/2024
Right=1

 

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Use #duration(1,0,0,0)

    • gaby58's avatar
      gaby58
      Frequent Visitor
      1 year ago

      Thank you, could you please let me know how to use this