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(), ""))
We have a large Smartsheet used in our warehouse that is on throughout the day. It automatically refreshes via a chrome browser extension every hour. It is the sole use of this computer, no other programs are run. The computer is generally on 24/7 but sometimes it does manage to switch itself off. The refresh needs to…
This discussion was created from comments split from: Can't access sheets.
I'm a newbie and have signed on. I'm wanting to use smartsheet as proposed in the below youtube promotional video. Has anyone worked out how to do this, I assume we could locate templates etc. But it seems like you need to be an expert in Smartsheet or pay for somone to set it all up?…
