Add a column to a table that sums all of the numerical cells in the same row. Useful for tabulating sales numbers or creating a balance sheet.
Clean phone numbers of unwanted characters, such as parentheses or plus signs
Join data points across multiple columns and insert characters between each entry
Remove duplicate rows from a table based on criteria that you supply. Choose how many duplicates to keep or merge duplicates.
Compare two lists and remove data from the first that exists in the second in order to prevent overlapping data.
Find the Min or Max of a data set to quickly summarize large reports
Add data to your dataset by pulling in additional data from an external data source.
Automatically remove extra spaces from data points using the Find/Replace object
Score prioritize and dedupe leads based on your own criteria to make sure you only get in contact with the highest probability leads at a given company.
Split full name fields into their constituent parts (first, last, etc.) while taking into account middle names/initials, prefixes, suffixes, and other quirks.
Use if/else logic to automatically apply data labels or filter out new data as it comes in