INDEX MATCH or something else?
I need your help setting up this formula in Smartsheet, since we don't have the formula LOOKUP, as I have in excel.
I have this table, where every time I add the [Site] number: 301, 302 or 303, it will look for the last [Actual Visit End Date] for the specific site number, and bring the last day of the visit on the column [Last Visit Date] highlighted in yellow. However, the formula I added INDEX COLLECT is always bringing from the row = 1. Is it possible to create a dynamic formula for the row to look for the last?
Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!