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

Find more posts tagged with

Formulas

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.