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(), ""))
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
When building this report an incorrect filter was added to the report (see picture). After it was added, we were unable to delete the filter, edit anything within the report, or edit columns in the sheets tagged to the report. Does anyone have a solution to this?
Is there a way to see where data is coming from if it is input or copied into a sheet by an automation? I have a sheet that is receiving to lines of data every night. I am not sure where these two lines of data are coming from. Initially I thought I was just failing to delete everything I didn't need after a sort, but I…
