Is there a way to get a specific string to return if all rows in a column are null?
My data comes daily with 3 columns, "Name," "Action," and "Items" of around 500 rows and i've set my workflow to add columns with the date as in the below table. On some days there is no data so the file comes with the "Action" and "Items" columns with the dash and 0 in all 500 rows but the "Name" will return all nulls. On days where there is no new data and all Names are null I want to return "no data today" in the first row of the "Name" column. Then I filter out all the rest of the nulls and my summary will show "no data today" for that date. I've been working on this all morning but can't pull it together and I haven't found anything here. Seems like there'd be a simple tool or formula that would get me what I need in one step. Thanks for any help you can provide.
Date of Entry | Name | Action | Items |
11-Dec-24 | (null) | - | 0 |
11-Dec-24 | (null) | - | 0 |
11-Dec-24 | (null) | - | 0 |
11-Dec-24 | (null) | - | 0 |
11-Dec-24 | (null) | - | 0 |
11-Dec-24 | (null) | - | 0 |
11-Dec-24 | (null) | - | 0 |
@Rob48 you can use the count record tool to take the total count and count the Null() values and if both are matching means all the fieids are null then you can update the first cell value of name field as "no data found", sample attached
deleting earlier response