And another question about Clay formulas / updating in bulk π
Is there a way to quickly find / filter "overwritten cell values"?
Also please let me know why 'overwritten cell values' didn't show up during my video when I edited the column?
Is there a way to Find & Update cell values in bulk? (like in Excel / Google Sheets)
If I use Clay formulas, will it overright the stuff we had?
Quick video explanation: https://www.loom.com/share/52b990e7effb495094489139b02efce3?sid=e25d400c-4bfd-4733-91c0-8d97c0e9fa06
π€ You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Hey Daniel, thanks for reaching out! Will answer your questions sequentially: 1. Finding Overwritten Cells: There isn't a direct way to filter for overwritten cells since a human has to perform this action. The idea being, you shouldn't have to overwrite anything. However, if you end up using lots of overwritten cells, a workaround could be creating a filter for only rows that have an "Error" which should act as an indicator for which cells need to be overwritten. Or you could create a checkbox column and whenever someone overwrites a cell in the designated column they would check the box so you could filter by which cells were overwritten. Personally, I'd rather try and solve the problem and avoid needing to overwrite cells than try and account for them. In this case, some of the 'Error (website does...)' columns when re-ran, has successful results which provides an easier alternative than having to overwrite a bunch of cells. 2. Overwritten Cell Not Showing Up: Try refreshing your page, clearing cache, and then re-editing this overwritten cell - problem should alleviate itself. 3. Find and Replace: There is not a bulk update that's like the Find and Replace function you'd find in XLSX. However, our formula column essentially performs the same function of 'If X criteria is met, do Y, else do Z'. For example, with the Thomann Music situation. You could create a column that says "if 'cell' contains "Thomann Music" return Thomann, else return nothing." which would achieve a result similar to 'Find and Replace' by creating a new column that contains only this updated name. Which you'd then need to use a 'merge column' to create a final 'Company Name Normalized Final' column that merges all adjustments tangent to this. 4. AI Formula Overwriting: If you create an AI Formula Column it will return whichever parameters are defined by the formula unless you overwrite it after it's created. Hope this helps! Please let me know if you have any other questions! :) Example of Finding Overwritten Cells: Filtering the 'D2C eCommerce' column (the one of the left) - if you filter only for columns that contain the word "Error" you should find all of the columns where you'd have to manually intervene and overwrite the result. https://downloads.intercomcdn.com/i/o/w28k1kwz/1231449195/945a70510dd30f1ffa457fe2a432/CleanShot+2024-10-28+at+10_56_25%402x.png?expires=1730149200&signature=b9f5b8c99a91f0e9a2c21560320336ccb12bd6ec15047762265048bd18da999b&req=dSIkF816lIBWXPMW1HO4zUUP%2BkkUjNMOiLct431qGwvHjZ%2BPhz1TY27ugSaS%0AYqyT%0A
Thanks Owen! Tried it, it worked