Combining two actions into one formula

Hi,

I am attempting to set the value of a drop down based upon other values in my sheet.

=IF(AND([Subscription End Date]@row <> TODAY(), [Add Request Type]@row = "Edit Seat"), "Active", IF([Remove Request Type]@row) = "Subscription Cancellation", "Cancelled")

The first argument in the string works great. When I attempt to add the second string, "IF([Remove Request Type]@row) = "Subscription Cancellation", "Cancelled")", I get "INCORRECT ARGUMENT"

Can anyone see my mistake?

Best Answer

  • Todd Smelser
    Todd Smelser ✭✭✭
    Answer ✓

    Disregard. I figured it out:

    =IF(AND([Subscription End Date]@row <> TODAY(), [Add Request Type]@row = "Edit Seat"), "Active", IF([Remove Request Type]@row = "Subscription Cancellation", "Cancelled"))

Answers

  • Todd Smelser
    Todd Smelser ✭✭✭
    Answer ✓

    Disregard. I figured it out:

    =IF(AND([Subscription End Date]@row <> TODAY(), [Add Request Type]@row = "Edit Seat"), "Active", IF([Remove Request Type]@row = "Subscription Cancellation", "Cancelled"))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!