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?

Find more posts tagged with

Accepted answers

Todd Smelser

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"))

All comments

Todd Smelser

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"))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.