Sign in to join the conversation:
Hi,
Is there a way to find the Grandparent or Parent has a particular string/word?
I have tried PARENT(PARENT()) and ANCESTORS(), didn't work. Appreciate any help.
Hello Meenakshi,
You'll want to use FIND with PARENT, for example:
=FIND("Word", PARENT())
More info on FIND is available in the help center: https://help.smartsheet.com/function/find
Hi all. My team is currently using a sheet to track tasks and hours spent on each task, for each week of the month. There are 4 different types of tasks (Project, Initiative, Ad Hoc, Daily Task), and some of out project managers work on the same project or initiative. I am trying to create a COUNTIF formula to count the…
Okay, so I have been working this problem for a few days and it's officially making me crazy. Here's the problem statement: I have 3 intake sheets for different business units. Each has an Auto-Number column that has a prefix for the BU. I need to consolidate all of the attachments from those 3 sheets into 1 sheet. So on…
I am trying to get a formula that will count the number of times a date appears in a particular column.
