Formula to move a cell from one sheet to another based on conditions

Hi all,

I'm currently using Zapier to move data from a google drive to a data source Smartsheet. During the transfer, sometimes there are multiple rows with the same claim numbers on the data source sheet (that part isn't going to change unfortunately). I have a separate summary sheet that that pulls the information I need from the data source sheet using an match/index function using the claim number to match.

On my summary sheet, I'm hoping to have some kind of automation or formula that will only pull over new claim numbers that does not exist on the summary sheet. Once the new claim number is on the summary sheet, the functions automatically calculates the data I need.

I don't know if this will help, but here's the summary sheet

Here's the data source screen shot.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!