-
Using SumIFs and Find referencing other sheets
I am trying to sum percentages for any tasks that are greater than 0% and contain certain text - in this example, "MFA" , among a string of text in a column. For example, the entire task name could be MFA deployment or MFA training but I want to search for any tasks that have "MFA". I have this formula started but keep…
-
Counting matches between 2 columns
I am trying to see which customer numbers repeat from one week to the next. I have a column for last week, then one for this week with client #'s and this formula to look for matches. =MATCH([10.7.22]@row, [9.30.22]:[9.30.22]) From the image, clearly there are numbers in 10.7 week that are in week 9.30, but coming up as…
-
Highlight a specific cell not the entire column/row
I'm looking to only have child rows highlighted when the value is greater than one. Currently conditional formatting only allows for applying a format to an entire row, or to all the cells within a column (Parent + Child) are there any formulas I can embed in a child row cell that will only highlight for that specific cell?
-
Getting #invalid data type error for this formula
=COUNTIFS([Engagement Phase]:[Engagement Phase], "COMPLETED", YTD:YTD, YEAR(@cell) = 2021)
-
Multiple IF statements then function
Hi, I'm trying to see if what I want is possible. I'm using it for a simple resource capacity purpose. I have columns for Assigned to (Different resource names), Status (In progress, on hold, complete), and Max capacity (drop-down list of warning signs). This is what I want: When In progress number reaches 5 per resource,…
-
VLOOKUP versus INDEX MATCH in this situation?
I have two smartsheets which I would like to tie information between. The primary sheet (Formula Test) has a column for "Date Submitted to AHJ". The secondary sheet (Submittal Log) breaks this down further into "Date Submitted (Local)" and "Date Submitted (State)" depending on the needs of the project. In the secondary…
-
Index Match/Collect/Join?
I'm struggling with the right syntax for the formula I need and would love some help. On my reference sheet I have a list of countries in a column and the list of various entities across the top. Then I have the names of the people who are responsible for each country (in total I have 195 countries). On my main sheet I am…
-
Formula to flag cell, based on level decreased in another cell
Hello All, After running into a dead end, I am in need of some guidance. Currently I am trying to find a formula solution that will flag a cell, if a Partner tier/ level decreases in another cell. The sheet I am using is linked to another sheet that tracks the Partner's current tier/ level, which is updated weekly. At…
-
Reassigning set up time by a dropdown
My group (10 people) is using the Calendar app to visualize work assignments, some of which are granted set up days. My boss has asked if it would be possible to reassign set up time to other employees with a dropdown. For example, is it possible to make the "1" in Brian's "Set" column on 10/26 go away, and "1" show up as…
-
How to calculate days between two dates
I'm using NETWORKDAYS to exclude weekends, however, I'm getting an "Invalid Data Type" error. Both columns are date columns. =NETWORKDAYS([Date of Verbal Agreement]@row, [Module Go-Live Date]@row) Thanks for your help!