-
Help with a formula
Hi! I'm having trouble figuring out a formula for the following situation. I have a column called "date applied". I want to know how many candidates applied per day. I also would like to add to that more filters I.E. location. Meaning I want to know how many candidates applied PER DAY PER LOCATION. Similarly I have a…
-
Levels formula
Hi all I am new to smart sheets, and I was after the formula for Levels and cross-referencing % to give a result. I have the following code in levels, but I need this to be more intelligent. =COUNT(ANCESTORS()) This returns the Uppermost parent as 0, Next level as 1, last level as 2. Is there a way of looking at the %…
-
Help with if max collect formula
Hello, Sorry I know there are already questions on this but I'm not getting it. I have a column [Users] of duplicate users, and a second column with unique numbers [Row ID] In a third column I am trying to get "Ignore" or "Select" based on the highest number per user So in the example above the PCUK832 should say ignore…
-
Cell Linking
Is there any way to stop a cell link from updating at once it has been populated? I am using the INDEX/MATCH formulas to assign a person to a task based off of a state assignment list. Once the task is completed, I do not want that person's name to change, even if the state assignment changes in the future. Any help is…
-
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in dropdown
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in multi select dropdown ? Solving for: How many "Devon's Corner" Leads do we have by Location Type - "Bar" or "Brewery".. If any or both of these options are selected, they should be counted as 1 =COUNTIFS({Brand Type 1}, "Devon's Corner",…
-
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…
-
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…
-
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"…
-
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 -…