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(), ""))
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
