Automatically Add recent changes information to a row.

hari_23

Hello,

I'm trying to look If there is an option to automatically update the changes happened in the worksheet from past 10 days in to new column (Lets assume the column name is "History_Past10Days")

Information I'm looking in this column(History_Past10Days): All the column Names updated from past 10 days

Ex: Sheet has 20 col's , Each column name col1,col2....... and after 20 col's the new column would be History_Past10Days and this column has information of the changes happened in that particular row from past 10 days if there are no changes from past 10 days this would be empty.

As mentioned in the above is it possible to do it in Smartsheet?

Thanks

Genevieve P.

Hi @hari_23

Smartsheet doesn't currently use a separate column to store historical data, but depending on your plan type you could use the Activity Log of the sheet. You can use a date filter to show just the past 10 days and filter by change type, such as a cell change:

Cheers,

Genevieve