-
Sumif matches criteria from multi select dropdown
Please help, i want to sum the Time Required in case the Week Number column has 1 and update Status is Monthly. I used this below formula but its not working. SUMIFS([Time Required (Hrs.)]2:[Time Required (Hrs.)]6, [Week Number]2:[Week Number]6, HAS([Week Number]2:[Week Number]6, "1"), [Update Status]2:[Update Status]6,…
-
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"…