Sign in to join the conversation:
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".
=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"?
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
