Pull in most recent form entry only
I am trying to add an indicator to use for a report to only recognize the most current form entry for a date range. Specifically, I am using a auto fill "created" column and the collect functionality as follows:
=IF(ISBLANK(Created@row), "", MAX(COLLECT(Created:Created, [Week Indicator]:[Week Indicator], "1")))
However, this isn't really the greatest way to do it since I have to do multiple checks.
Is it possible to create a formula where I can check for the Team member name, matching start date, and apply an indicator if the Created Date is the max value?
Below is a snip of the form I'm making. The column "Most Current View" is where the IF formula above currently sits, but it's not working right =)
Help Article Resources
Check out the Formula Handbook template!