Formula to determine the date that another cell was populated

Hi,

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,

Sharon

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!