Is it possible to set up an If statement on a “Child” field dependent on a date in the Parent field?
What I am looking to do is have a field fill in Yes or No based on the Impacted Article Complete Date in the Child row and the Alert Expiration Date in the Parent Row.
If the Impacted Article complete Date is prior to the Alert Expiration Date, the field would fill in Yes. If the date is after the Alert Expiration Date, it would fill in No.
Kristie Diersen 😀
Best Answer
-
I think I am following now. Give something like this a try...
=IF([Impacted Article Complete Date]@row <= PARENT([Alert Expiration Date]@row), "Yes", "No")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Would you be able to provide a screenshot with sensitive/confidential data hidden, removed, or replaced with "dummy data"?
From what I am understanding, it should be possible, but I want to verify first before providing a solution that may or may not work for you.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
What I am looking to do is have the Article Published before Expiration Date field fill in Yes or No based on the Impacted Article Complete Date in the Child row and the Alert Expiration Date in the Parent Row.
If the Impacted Article complete Date is prior to the Alert Expiration Date, the field would fill in Yes. If the date is after the Alert Expiration Date, it would fill in No. Then the No would trigger an automation Alert Someone that I would set up.
Kristie Diersen 😀
-
I think I am following now. Give something like this a try...
=IF([Impacted Article Complete Date]@row <= PARENT([Alert Expiration Date]@row), "Yes", "No")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!