IF used in MAX COLLECT?

Hi

Our Jobs done sheet is populated through a form to give.

We must make 2 visits contracted visits a month. However, sometimes we are called out for a repair.

I have a sheet that calculates the days since we carried out a site visit.

Date attended =MAX(COLLECT({Jobs Range 2}, {Jobs Range 1}, site1))

range 2 = Date. Range 1 = Name

However, I only want it to return the dates of the 'contract' and not repair as John should be 5 days since done.

Is it possible to return the MAX date IF job type = 'Contract'?


Thanks


Hall

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!