This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Am trying to set status flags for a entire table result based on a single column. Below is an example. I wanted to build out a record say Table_status_check which should state success or require rerun based on the overall nature /contents of the Summary_check column in the below table irrespective of the number of records I have in this grid.
I have attached a workflow that I think should get you what you're looking for. Within the workflow, I showed how the solution would work with both of your examples. I first added a formula to check if the summary check field contained the word error. If it did, I created a new field with a value of 1. If it didn't, I made the new value a 0. This way, you could take the sum of this field and if it's greater than 0, you know there was at least one error.