How to see what row data has been updated with datauploader?

Julia C Peterson

Is there any way to see what data on a sheet has been updated/modified after a datauploader run?

Genevieve P.

Hi Julia,

What about turning on Highlight Changes within the sheet? (See here.) This will also highlight manual changes that anyone else may have done though, since you last looked at the sheet (or within the timeframe you select).

Alternatively, you could set up a helper Checkbox column that checks a box during the workflow.

You can use an expression in Data Uploader to input the 1 in that helper checkbox column.

In the data uploader workflow in the Mapping window, in the Input Column/Expression left side of the window, choose the option "New Expression" from the bottom of the drop-down list to Map to the expression to your Checkbox column. 

Then have this expression simply be =1

This will check the box in Smartsheet for the rows that were updated.

Cheers,

Genevieve