Formula to determine the date that another cell was populated



I was trying to find an answer to a question that advised how I can show a date in one column that shows the date text was first added to a previously blank cell in another column.

So I have one column called "Date of response" and I want that to auto populate with a date when another field is first updated i.e. "Category team response" which is a text field.

I have seen that an enhancement request was submitted in 2018 for this functionality / formula, but not sure if was ever actioned.

I also saw a post about using a system generated modified by date field but I don't seem to have this functionality available when I create a column - no idea why? But also this would auto update with every change so not a perfect solution.

Any advice would be greatly appreciated.

Kind regards,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!