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
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!