INDEX COLLECT with MAX and ISBLANK

Hi folks, I'm a bit stuck with this formula. Hope someone can help.

I want the Link to Latest Edit column to pick up the Latest Edit for whichever project is indexed in the row. The Current formula is leveraging my Autonumber column and picking up the last added with a MAX.

Like so:

This all works fine except that sometimes my users forget to log their latest edit and that field is left empty. In this case I want the formula to look for the last one added for that project, basically the MAX where Latest Edit is not blank.

I tried to drop a second criteria into the COLLECT to NOT Collect if the Latest Edit field is blank – presuming that the formula would then look to the MAX that was not blank.

Alas, I can’t seem to get it right. Where am I going wrong? Any advice?

Thank you.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!