Is it possible to set up an If statement on a “Child” field dependent on a date in the Parent field?

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

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. 

Best Answer

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    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.


  • 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.

Sign In or Register to comment.