How might I write a multi-row IF formula to fill out the "Loaded Time" in the screenshot below (I manually filled this column as an example of what I'm looking for), in so that if the "Status" column does not contain the text "Load" for a specific order, the "Loaded Time" column is then populated with "unknown" for all of the cells corresponding to that order number?
Hi @WooPigSooie
Here's an example:
- Multi-row to populate loaded time (key here is grouping by order)
- Formula to update nulls to unknowns
You can combine this into one multirow tool but for simplicity's sake I separated into two tools
