Missing IF?
I am using the following formula to return the oldest (no of days) unanswered question type of 'alterntaive proposal'
=MAX(COLLECT({Days since submission}, {Question Answered}, 0), {Submission}, "alternative proposal")
However, it returns the oldest of all question type alterntive proposal so answered and unanswered.
makes me think there shoudl be an IF in there about only the unanswered ones?
And if so, how would it be constructed.
If not, what else have I missed?
Thanks
Answers
-
Hi Phil,
I did a quick replication to review.
Looks like it works for me when I shift the bracket after 0 to the end, thereby having COLLECT work across both criteria.
=MAX(COLLECT({Days since submission}, {Question Answered}, 0, {Submission}, "alternative proposal"))
Hope this helps?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives