An article about questions from Smartsheet community members and answers from jmyzk_cloudsmart_en.The questioner has a question regarding how to move cells when moving data from Google Drive to Smartsheet. Here are some questions and answers from Smartsheet community members.
User question summary
murphyspccms uses Zapier to move data from Google Drive to a data source sheet in Smartsheet.However, there may be multiple rows in the data source sheet with the same call number.On the summary sheet, he wants an automation or formula that only gets new call numbers that are different from the existing call numbers.
Summary of my answer
jmyzk_cloudsmart_jp suggests how to get the new 'claimNum' from another sheet to the summary sheet instead of showing a concrete way to 'move' a cell to another sheet based on a condition.
Question and answer details
murphyspccms: I'm currently using Zapier to move data from Google Drive to the data source Smartsheet.During transfer, there may be multiple rows with the same call number in the data source sheet.
jmyzk_cloudsmart_en: Hello @murphyspccms.I can't give you a concrete way to "move" a cell to another sheet based on a condition, but I figured out how to get the new "claimNum" from another sheet to the summary sheet.
This method uses the INDEX(range, MATCH(search_value, range)) method. demo dashboardYou'll understand what I mean by looking at
Conclusion
jmyzk_cloudsmart_jp's answer doesn't show a concrete way to move cells based on a certain condition, but an approach to get the new 'claimNum' from another sheet to the summary sheet.This method is for effectively managing multiple rows with duplicate call numbers that exist in the data source sheet.This answer provides useful information for Smartsheet users with similar issues.