Formula to Find Last Non-Empty Cell In a Row
I am using a sheet that tracks counts of different products by location, which gets updated in 30-minute intervals (product location by row and time intervals by column). My goal is to use a function to automatically pull the most recent count for each product, which would require the function to check for the last non-empty cell in a given row and count that number.
I've found a function that appears to work just fine in Excel/Google Sheets, but always comes up as #UNPARSEABLE when used in Smartsheet. Formula, below, links to the original page that I found it on which explains how the formula works.
Does anyone know how to help me make this work?? Does Smartsheet not have the capability to do anything like this?
Thank you in advance!!
Help Article Resources
Check out the Formula Handbook template!