populate column based on parent rows

Maz Uddin

Hi All,

Need some guidance

is there way to automate column 20 to auto populate whatever the parent cell on task name?

@Paul Newcome It's Maz Uddin, this is a new account. Please can you answer if you have time.

jmyzk_cloudsmart_jp

Hi @Mazy

You can use the PARENT function.

=IF([Column19]@row = 1, [Task Name]@row, PARENT([Task Name]@row))

https://app.smartsheet.com/b/publish?EQBCT=e2d4095941c348c6825af8b04bb885a8

jmyzk_cloudsmart_jp

Hi @Mazy

You can use the PARENT function.

=IF([Column19]@row = 1, [Task Name]@row, PARENT([Task Name]@row))

https://app.smartsheet.com/b/publish?EQBCT=e2d4095941c348c6825af8b04bb885a8

Maz Uddin

@jmyzk_cloudsmart_jp Thank you!

jmyzk_cloudsmart_jp

Happy to help!😁