03/21/18 Edited 12/09/19

I am trying to write a formula that has multiple steps to it.

I want it to see if the project is completed then to give me the Max date of completion.

Max Completion Date.JPG

Popular Tags:


  • L@123[email protected] ✭✭✭✭✭
    edited 03/22/18

    =MAX(COLLECT(B:B, C:C, "complete", A:A, "Act A"))

  • Mike WildayMike Wilday ✭✭✭✭✭

    Are you trying to complete this in Smartsheet? If so, here is the Smartsheet version. It assumes your columns are titled the same as your headers in the excel example shown.

    =MAX(COLLECT(Date:Date, Status:Status, "Complete",[Activity Type]:[Activity Type], "Act C"))

  • That works!  Thank you.  I am doing this in Smartsheet but I did my example in Excel.


Sign In or Register to comment.