Missing IF?

Phil Wightman
Phil Wightman ✭✭✭✭✭✭
edited 09/20/21 in Smartsheet Basics

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

Tags:

Answers

  • Jason Albrecht
    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?

    Hope this helps and that you have a great day,

    Jason Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work