My nested COLLECT function's Criteria does not appear to be working because the formula runs into errors when a duplicate date is found before the actual date that should be being pulled. =INDEX([Base…
Hello. I have setup a JIRA extract to provide raw data on which to develop an operational dashboard. I need to be able to count 'closed this month' on the dashboard. I am getting a closed date for eac…
I am using this formula in a helper column to identify which of my rows are "parents" however I would also like to Identify Rows that are Projects or also "Parents", but have 0 children " so that I ca…
I have two sheets---one with a list of program that includes rows with a cell that has a list of course prefixes. EXAMPLE: ROW 1--->Doe, John | doej@xx.com | BUS,CUL,MGT ROW 2--->Smith, Elle | smithe@…
Hello, I have a requirement to calculate the remaining shelf life of products at the time of receiving in percentage. My formula is: (Production date + Expiry date) / (Expiry date - Delivery date). Th…
Hi all Is anyone aware of any time functions is recent updates, I what to be about to calculate how minutes/secs(don't mind either) from a system column also is there an hour or minute function in Sma…
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that ev…
Hey folks, Working on a sheet to sum up if checkboxes are selected and running into an issue. The formula I have now is- =SUMIF(PRD50, 1) + IF(Stories50, 1) + IF(Assets50, 1) + IF(Wires50, 1) + IF(Com…
I've created a Group and can track assigned tasks in a Resource View with the group dynamically. Is there a way to access the group list in a formula on a sheet? In my sheet, there is an "Assigned To"…
Hi guys, very new to formulas so not sure if this is even possible and/or makes sense. I have a web form that lets the user submit data for: NEWS PIECE TITLE NEWS PIECE FILE (UNC path) Then, I send an…
