Last modified for specific cell



I am trying to figure out if there is a formula to basically look at a cell and see when a specific cell is modified. I am trying to use this for KPIs.

For background:

I have a workflow where if something is rejected by my engineering department the person who created the request is then triggered to answer engineering's specific reason for rejection. I need to basically know the date that engineering created the rejection, and the date that the rejection was clarifying information was responded to by the non-engineering individual. Is there a way to do this?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!