Sheet Compare

Sheet Compare

Peggy PPeggy P
edited 12/09/19 in Using Smartsheet

I receive a weekly report that I need to compare to the previous week's report to determine what changes have been made over that week. If possible I would like to be able to do this compare in SmartSheet (instead of using Spreadsheet Compare in Excel). 

Does SmartSheet have this functionality (like the Spreadsheet Compare tool in Excel)?

Any help would be appreciated.

Thanks -Peggy

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Peggy,

    You might use a combination of Highlight Changes and Cell History. There is also the Activity Log.

    Would that work?

    I have a few other ideas. Can you share a screenshot or more information about the process?

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • The current week and previous week reports are sent to me via email. These are excel spreadsheets that I have been uploading and completing a manual compare (which is time-consuming and inefficient) in SmartSheet - line by line.

    There are multiple date columns in the report. I'm not sure if it would be easier to just complete the compare in excel and then upload to SmartSheet if there isn't a compare tool in SmartSheet. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Can you maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    Have a fantastic day!

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • I apologize for the delay in getting back to you. I had an unexpected project at work and then a personal matter. I will share my sheet with you - hopefully by week end things will calm down.

    Thank you -Peggy

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    No worries!

    Have a fantastic week!

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • I ended up just doing a compare in excel and then uploading after removing duplicates (if there was any). It seems to be working ok - just wish SmartSheet had a compare function and/or remove duplicates capability. 

    Thank you for your input.

    Peggy

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    Glad to hear you solved it!

    Great ideas! That would be excellent additions to Smartsheet features.

    Please submit an Enhancement Request when you have a moment.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Just curious if there was any followup or conclusion to this thread. I am also interested in such functionality and from just a few simple web searches it seems like others in the community as well.

  • I'm still using excel to complete my tasks. Please submit an Enhancement Request for this - link below:

    Maybe if enough of us ask, it will be on the list....

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    If you have access to the Smartsheet itself, you could use the Highlight Changes feature.

Sign In or Register to comment.