-
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},…
-
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…
-
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
-
what formula would I need to use for this to work
Good afternoon, I am new to Smartsheet and would like to input a simple formula into my sheet. I have a column titled "Delivery date" I would like to insert a symbol or checkmark or something into another column titled "ENTER MSL" when the date in the "delivery date" column is 14 days or greater. I have tried using IF,…
-
Is there a formula to AVG a column after I have it converted to min:sec from seconds?
I have this formula in to convert seconds into Min:Sec. Now I need to AVG the time in the Min:Sec column. Is there a formula for this? =INT([1st Response Time (sec)]@row / 60) + ":" + ([1st Response Time (sec)]@row - (INT([1st Response Time (sec)]@row / 60) * 60))
-
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…
-
Formula to Count the Name Once
Good Day All: Does anyone know how to create a Count Formula to Count the Name just once Based on the Criteria? For Example: Count the Name (Assignee Column) Once in Sprint 5 (Sprint Column): John Doe John Doe John Doe Jane Doe Jane Doe Jane Doe Therefore, my total count should be 2 (John Doe and Jane Doe). Thanks
-
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…
-
Calendar View: Moving Resources
Good afternoon On some of my sheets, I am able to move around items in calendar view and in others, I am not. I don't understand why and it would be helpful I could fix this so I can move data in my calendar view and some of my resources prefer working in the Calendar view.
