Sheet to reference last record from a form

I have seen numerous answers to this question, but I am still confused about the syntax. e.g

I have an Smartsheet form (Input form) that collects the PSHC, peak shift head count.

I have a separate sheet that needs to reference the last record in the input form. When I try to use the formula suggested by the link above, I get an unparseable error. I hope it's simply a syntax error on my part.

MAX(COLLECT([Created]:[Created], [PSHC]:[PSHC], =[PSHC]@row)), 1, 0)

I originally tried a simple reference to the entire PSHC column, but it only linked to the first record, not the latest one.

Please advise,

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!