I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics (schedule, cost, etc.). Section on project metric sheet is "Most Recent Status Log Entry" where the latest date and text from the status log needs to be placed.
My code for the note is
A. =index(collect([{Status Log Range 4},{Status Log Range 2},max({Status Log Range 2})),1))
I'm getting an #Unparsable error.
Alternative code check for troubleshooting
B. =MAX({Status Log Range 7}:{Status Log Range 7})
I'm getting an #Unparsable error.
Alternative method to get the same result as A.
C. =INDEX({Status Log Range 4}:{Status Log Range 4},match(max({Status Log Range 7}:{Status Log Range 7},{Status Log Range 7}:{Status Log Range 7})
I'm getting an #Unparsable error.
Status Log
Project Metric Sheet