I have a number of processes that get data out of SmartSheet and process information for a row if a particular cell on the row is blank. However, as I am getting more data into the SmartSheet, it is taking longer and longer to process. It takes approximately 20 minutes per 1000 rows just to check if a cell has a value or is blank.
Does anyone know how to set up the Invoke SmartSheet Operation to apply a filter and then only process through the filtered results? I am having trouble using the ListFilters and GetFilters functions that are included and I am hoping someone can help walk me through how to properly use these.