Automate a rent increase on certain date

CarriG ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to automate a rent increase on a certain date. I have a table with Tenant ID, Rent Increase Date, New Rent amount. I would like to reference this in another sheet, so that when the rent increase date arrives, it will return the new rent amount. 

I can use the Index and Match to pull in the amount, just needing it to update on a certain date is what is giving me trouble. 

Any point in the right direction would be appreciated. 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!