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"?

Can I count cells between number thresholds if the cell also has text in it?
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
RYG Formula based on Due Date and Percentage complete
I am struggling to create a formula for the RYG symbols. I would like to base it off percentage complete and due date. What I am looking for is: Red = Due date <2 days less than .90 and anything past due Yellow = Due date < 4 days less than .50 All other green
How do I get the exact number of Years based on the date column (no more rounding up)?
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…