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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives