Sign in to join the conversation:
I need a cross reference formula using countif a specific value in a multi select column is under a parent from another sheet.
You cannot reference hierarchies directly with cross-sheet references. You would need to calculate those values on the source sheet, then pull them to your target sheet.
I am getting an #Unparseable error on the following formula My time is already in military time. I am trying to get hours worked.
Hi, I have a 2 tracker sheets, they both have columns for 12 periods, P1, P2 etc., rather than the names of the months as they can start at any time and run for 12 months. First tracker sheet - The start date for the tracker can be, the first day of any month. Second tracker sheet - The start date can be any day of theā¦
Does anyone knows if its possible to create a document using more then just 1 line a time, meaning if i have 10 rows that i want to include into same document : example Creating a packing slip from multiple lines
