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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!