Sign in to join the conversation:
Can anyone suggest a formula to return the earliest and latest date within a child column?
for the earliest date range you can use = MIN ([xx] 1 : [xxx] 19.
Where the XX is your starting position and XXX is you ending position, of course the row numbers will vary to what you need
I believe using the word LARGE instead of MIN will give the most recent date.
Hope this helps.
That works for a range - thanks!
Any idea how to constrain the search just to a cell's children?
I'm glad the range worked. I'm not sure about a cell's children. Would it be possible to show me an example that's similar or if not too private part of the sheet you are working in?
=MIN(CHILDREN([Date Column Name]@row))
=MAX(CHILDREN([Date Column Name]@row))
If you are putting the formula in the same column as the children you are referencing, then you wouldn't even have to specify a cell.
=MIN(CHILDREN())
=MAX(CHILDREN())
That worked, thanks!
Happy to help.
How to return the latest Children date only if all the Children are populated with dates? I tried this, but did not work.
=IF(CHILDREN() <> "", MAX(CHILDREN(), ""))
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?
