Formula for Updated By and Updated Date Fields


Hi all,

Question about a formula I am trying to get started. I want to make sure this is possible before going much further. I have ONE sheet that has four different reports pulling off of it. Each report has 5 lines that Project Leads can update. We are want to have two fields (in the sheet) that autopopulate the Name of the person and the date that updates are made to ANY one of the 5 lines in ANY one of the 4 reports. I know I can use an index match formula to help me pull the name from the login email address but want to make sure the other automation is possible first.

Any advice is welcome! TIA.


Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!