Retrieving last month's value
Hi, I am trying to retrieve the previous months value based on a primary identifier.
I can set up my smartsheet to either move past values to another sheet or leave them all on a sheet.
The idea is when a user adds a new line item, with a primary identifier, the previous month's price can be automatically pulled into the row. the conditions im trying to put into a formula are
if primary identifier matches (using an @ row), pull value that was in the 'price' column for the most recent entry (based on 'as of date' column, it will be the last business day of the previous month) and put that value into the 'prior month, or most recent price' column
see screenshot of sheet setup below
Help Article Resources
Check out the Formula Handbook template!