Thanks for the comment! Can certainly make a video for counting with Children(). Are there any specific questions or use cases you'd like covered on that topic?
Really the use of the function in general. Maybe other functions that can be used with it. Just found it was a thing and there is very little out there on how to properly use it or what it's truly capable of.
@@Blackstaranime Great idea! This video shows a few use cases of the CHILDREN() function th-cam.com/video/oFs-GFD6vPg/w-d-xo.html Though I will plan to make a more thorough video using hierarchy functions in general.
I am trying to graph due dates by month. My data crosses over into the next year. What do I need to add to my formula so it sees/knows the difference in 2021 and 2022?
Hi Penny! Date formulas can get tricky. Essentially, the formula would need to reference the relevant month and or year in question. Oftentimes, I'll create Sheet summary date fields to reference in formulas so I can get data for past months, future months, years, etc. There are some useful formulas for dates you can view at app.smartsheet.com/b/publish?EQBCT=fa150bb4bb6f4847bcf1dec995aefa41
Very clean video! Much appreciated. You should do one using the Children () function as well for counting.
Thanks for the comment! Can certainly make a video for counting with Children().
Are there any specific questions or use cases you'd like covered on that topic?
Really the use of the function in general. Maybe other functions that can be used with it. Just found it was a thing and there is very little out there on how to properly use it or what it's truly capable of.
@@Blackstaranime Great idea!
This video shows a few use cases of the CHILDREN() function
th-cam.com/video/oFs-GFD6vPg/w-d-xo.html
Though I will plan to make a more thorough video using hierarchy functions in general.
I am trying to graph due dates by month. My data crosses over into the next year. What do I need to add to my formula so it sees/knows the difference in 2021 and 2022?
Hi Penny!
Date formulas can get tricky. Essentially, the formula would need to reference the relevant month and or year in question. Oftentimes, I'll create Sheet summary date fields to reference in formulas so I can get data for past months, future months, years, etc.
There are some useful formulas for dates you can view at app.smartsheet.com/b/publish?EQBCT=fa150bb4bb6f4847bcf1dec995aefa41