-
Syntax for variable in JOIN(COLLECT)
so my current formula is =JOIN(COLLECT({OptRoadmapTestName}, {OptRoadmap Status}, "Live"), ",") + "," However, I'd like to include statuses of 'Live' or 'Build', but I cant get the variable syntax right. TIA
-
How to correctly use INDEX(COLLECT())
I am trying to create a cross-sheet formula that pulls the data from another sheet if it meets 3 criteria. In the source sheet, I need the following criteria met: 1. "Month/Year" column to be the same as the "Month/Year of Report" column in my target sheet. 2. "Activity code" column to be "2105532" 3. "Name" column to beโฆ
-
Difficulty with sumifs formula
I was hoping someone could help me. Having difficulty getting my sumifs formula to work. I am trying to sum a total if a project is closed and for projects closed within the year 2020. Currently this is the formula I am trying to use (tried different variations to no success): =SUMIFS({Cyndy Brewczak Project List Range 1},โฆ
-
VLOOKUP and Large returning Correct value but wrong Description
I have the VLOOKUP set up but itโs returning the wrong result.ย For example: According to the Large function, 6,990 is the amount that weโve spent the 5th most on so far this year, when I scroll through and find that total, itโs the Sidelaster Conversion that show's we've spent 6,990, however it comes back as the BDF Boxtoeโฆ
-
Help with percentage of text columns
I am struggling with finding the formula to determine the percentage of locations in North America, that are currently active. My sheet has 100 rows with different territories (North America, Asia, Europe, etc) and I want to be able to determine the percentage of "currently active" locations in each territory. Any help isโฆ
-
Duplicate Checker based on multiple conditions
Hello, I have a duplicate checker formula that was working perfectly until recently.. The recent change was that we started getting phone numbers in different formats (see screenshot). Here's the formula that has been working perfectly: =IFERROR(IF(LEN([Person - Phone]@row) = 0, "", IF(COUNTIFS([Person - Phone]:[Person -โฆ
-
Collect formula to return a value @row in cross sheet
I'm trying to get the following formula to work: =COLLECT({4.01 Backlinking Range 6}, {4.01 Backlinking Range 1}, [Root Domain]@row, {4.01 Backlinking Range 3}, [Date Last Backlink Live]@row) Range 6 is a range where when the other criteria are met, I want the value @row to return. Range 1 is a a bunch of "root domains"โฆ
-
Vlookup with Large formula as the search value
SOLVED* REALIZED THAT I HAD AN EXTRA ) IN MY FORMULA!!! Hello everyone, I have a list of items that pull from other sheets what we're spending on each one. From there, I have used the large function in a cell to pull the largest totals and rank them from 1 to 5 for a "top 5 spender list" I would now like to pair up whatโฆ
-
Converting a Vlookup to Index/Match within an IF and IFERROR function
I'm currently using this formula =IFERROR(IF(DSP@row = "", VLOOKUP(Code@row, {ClientNo}, 7, false), VLOOKUP(DSP@row, {ClientNo}, 5, false)), "") and it works great. However, I need to delete some columns on my reference sheet that are within the vlookup table. I want to convert the above formula to INDEX MATCH so I don'tโฆ
-
Reporting with on Sheets with Common Row Value
I love the functionality of creating roll-up reports that incorporate multiple sheets that have the same columns. What I can't figure out, and feel as though should be a possibility though is the ability to create a roll up report that combines sheets that have only ONE column in common. For example, let's say I amโฆ