-
How to count just the text.
Hello, I am using =COUNTIF({Chamber Range 1}, "start") to count the number or starts and it works great. but I also need to count the number of "queue" the only problem is queue is usually followed by a number EXAMPLE: queue 10. I don't care about the number, I just want to count the text. does anyone know of a formula…
-
Cells with a formula date calculation are changing automatically...help!!
Hello all - I'm throwing this out there as it's completely stumped us and I'm hoping this has happened to someone else and they know what's going on! We have a sheet that we have formulas created to calculate a backward scheduled start and end date for specific tasks (dependencies are not enabled). The February 8 date…
-
Need help with buried IF statements.
I need help with a formula that I think will have multiple IF statements. Please see below. I am trying to determine the Maint Tech YTD Score. For the formula, we will only be using the "Community Average Score", "Company Wide Satisfaction Avg.", and the "Score Delta". We are comparing the Score Delta to the Company Wide…
-
COUNTIFS Formula with Cross Sheet Reference
Hello, I am trying to do a countifs formula and I need to reference two columns in another sheet. I have copied the formula I am trying to use below. =COUNTIFS({2020 Q4 Validations Range 2}, OR(@cell = "Amazon"), {2020 Q4 Validations Range 3}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 3, 31))) I keep getting…
-
How to pull rows from a different sheet only if they're marked as "in progress" ?
Hi there, I'm looking for a way to pull rows from another sheet if they are marked as "in progress" (or any other status that's not "complete"). Ideally, I'd want to pull everything from that row and not just a single cell. Is there a way to do this? Thanks in advance!
-
Reference an entire column and sync it with another column in a secodn sheet
Looking to take all 150 rows from a column in sheet 1 and sync them to sheet 2. Any changes to sheet 1 should be reflected in sheet 2.
-
If i check this checkbox, then check another check box
I am looking for a formula that says... if i check this box on this sheet then go check another box on another sheet. What am i missing to make the 2nd box get checked when Purchased @ row 1 is checked? =IF(Purchased@row = 1, {other sheet Range 2} = 1, 2)
-
Sumifs formula help please
Trying to determine # of total hours if a specific program is listed. Seems simple but keep getting errors. Attempts below. Any thoughts? =SUMIFS({Team Range 9}, >0, ({Team Range 8}, FIND("Program", @cell) =true)) =SUMIFS({Team Range 9}, >0, {Team Range 8}, [\[Formula descriptor 2\]]@row)
-
If Formula that Autopopulates names
Hi! I need help with a formula that would do the following...... If John Smith was a Client Services Director that was assigned to two states (AL and LA), which formula would I use to populate his name into the column adjacent to the state every time either AL or LA was inputted into the "State" column? And would those…
-
IF-WORKDAYS Calculation
I have a sheet with a [Request Submitted] column. Our SLA to attend to any received request is 2 business days. So I'd like to add a column that highlights any overdue items. My logic is: If TODAY is 2 business days past [Request Submitted]@row, then "OVERDUE" Can anyone help with the correct syntax? Thanks.