"Active Last Month" Calculation?
I have created a Calculation Sheet (feeding in to a Dashboard) with Columns including "Started Last Month?" and "Ended Last Month?". Row data therein is either "Yes", "No" (or "#INVALID DATA TYPE" - not worried about this at moment).
I then have a further column, "Active Last Month?", which I want to report "Yes", "No" (or "#INVALID DATA TYPE" - not worried about this at moment).
The latest (but simplest) equation to fail I have tried is:
=IF([Started Last Month?]@row)="Yes",OR(IF([Ended Last Month?]@row="Yes"),"Yes","No"))
Comes back as "#UNPARESABLE".
Can anyone give advice?!?
Many thanks
Best Answer
-
It sounds like this is what you are looking for, but if not then please provide more detail.
=IF(OR([Started Last Month?]@row = "Yes", [Ended Last Month?]@row = "Yes"), "Yes", "No")
Hope this helps!
Answers
-
It sounds like this is what you are looking for, but if not then please provide more detail.
=IF(OR([Started Last Month?]@row = "Yes", [Ended Last Month?]@row = "Yes"), "Yes", "No")
Hope this helps!
-
-
Happy to help! 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!