Return a date to the parent 'start date' from a child 'date' column
Trying to use a formula to return a "date" from the child row if the "Day of week" is = to "Mon" to the 'Start date' column of the Parent row. =IF(CHILDREN([Day of week] <Mon>, 0) Not sure what I'm doing wrong.
I'll need to do the same thing for the Date that is equal to "Fri" to appear in the "Date" column of the parent row.
Any suggestions? ... did I make this too complicated? 🙃
Best Answer
-
Hi @malorie
Looking at your data, you might be able to simplify it. If your child tasks are always Monday to Friday and you want the first and last date in that range you could use a simple MIN and MAX of the dates in the child rows. Then you can ignore the day of the week.
In the parent row start date
=MIN(CHILDREN([Date]@row))
In the parent row date
=MAX(CHILDREN([Date]@row))
Answers
-
Hi @malorie
Looking at your data, you might be able to simplify it. If your child tasks are always Monday to Friday and you want the first and last date in that range you could use a simple MIN and MAX of the dates in the child rows. Then you can ignore the day of the week.
In the parent row start date
=MIN(CHILDREN([Date]@row))
In the parent row date
=MAX(CHILDREN([Date]@row))
-
Oh my gosh!! Thank you so much that worked perfectly. I'm not sure why I make things so complicated!!
-
I'm pleased the easy option worked for you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!