Welcome!

Check if a row is parent and starts with "abcde"

Hi,

Please can someone help with a formula to find if a row is parent and at the same time has a text that starts with "abcde".

Formulas

=IF(AND(LEFT(PARENT(), 5) = "abcde", COUNT(CHILDREN()) > 0), "Y", "N")

Change Y or N to what you need, depending on whether the formula meets the criteria.

Note that this will only check for children in the same column

Thanks for this. Is there a way to find if the PARENT OR the GRANDPARENT has the word "abcde"?

Permanent Row ID's without using Auto-ID
Is there a trick to creating a column of unique values for each row that will not change after it is created? I cannot use Auto-ID because the row then gets copied to another sheet that utilizes Auto-ID and Smartsheet limits that. I'm stuck and ChatGPT keeps making recommendations that don't work.
Autopopulate / Copy Certain Cells To Another Sheet
I have a sheet that has all of our orders on it. I have other sheets "Gantt" for each machine. I want each machine sheet to auto populate every order that is assigned to it, when an order gets assigned to the machine. I don't want to set an automation to copy the row from the orders sheet to the machine sheet because I…
Anyone resolved 'automatically adding rows to a sheet based on a trigger value' ?
Hi Community Facing a problem many others have posted about, but haven't seen a solution yet and wondered if it had been solved. I want to be able to add a row on a resource sheet for each project resource once a project has been set to 'X' on a Projects sheet. I have tried through automations but the daisy-chain limit…