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 https://community.smartsheet.com/discussion/20126/report-with-the-last-entry-to-each-persons-forms
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.
Help Article Resources
Check out the Formula Handbook template!