Missing IF?

Phil Wightman

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

Jason Albrecht

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?