-
Create Contact using INDEX/MATCH
I need to have a contact list populate based on the name of the PM entered into the PM column. Just so you are aware, I attempted, to change the PM column from a dropdown to a contact list, and the 22 workflows I had created all broke. So on my PM list, there is a column named PM, which is just text (this is the primary…
-
Count Index Match Formula
I want a formula to retrieve a count of how many nurses have a BSN degree by unit from a spreadsheet. I have a sheet with the list of units as the primary column and degrees listed for the other columns. The formula needs to look at the main data sheet for this number. Is this possible?
-
Stumped trying to add OR to an otherwise working equation
Hello, I have a working equation that I need to take one step further, but have had no luck with my attempts. I have a Status column that in it's simplest definition needs to return the values "Complete", "In Progress", or " " depending on the values in two other columns; ACTUAL START and ACTUAL FINISH. The list of initial…
-
Today Formula Working and not Working
Hey Folks, I'm having trouble the column HELPER|Today & Safety Issue (Not R/Y). That column should only say "Yes" when the submission was for Today, the HELPER|Today & Staffing Level is Blank and the Safety Issues is "Yes". The formula in that column works for the past submissions and todays submissions but is saying that…
-
Report not displaying rows
Can anyone assist? I have two reports with the same set up but for some reason my second sheet does not display the corresponding rows under grouping. In the first sheet it works fine: However in my second row, It's asking me to filter but does not show the rows even if I filter by date. Any idea on why? This sheet has…
-
Return a Future date based on criteria Weekdays only
Hi, I have this formula: =IF([Billing Arrangement]@row = "Prepayment", [Invoice Date]@row + 3, IF([Billing Arrangement]@row = "Direct Bill", [Invoice Date]@row + 7, 0)) Can anyone give advice to correctly write this to show WEEKDAY? [Invoice Date] column would be the date column I would point to.
-
Lookup highest amount with conditions
Hello, I think I am close but I am not sure how to add one more value to look up one more piece of the puzzle (country data) from the current formula I am using. I am not sure how to reformat the formula so that the formula also looks at the country. I am currently using MAX and COLLECT to check three columns (Role, Hourly…
-
Formula Question for multiple criterion
Good Morning, I almost have this cracked: =COUNTIFS({Emp Status}, [Emp Status]@row, {Rank}, "SGT", {G-300}, ="") I want to add another Criterion after "SGT" so it can track SGT and LT, but I am coming up short. This formula only works to see all SGTs who has taken G-300, but I want both SGT and LT. Any suggestions?
-
Any idea on using OR function with SUMIFS?
Hi Smarties, I understand we can use OR function with SUMIFS or COUNTIFS - I just couldn't figure out how. I am wondering if there is a solution to the problem below "OR can be used directly in a boolean column (checkbox, flag, star) or can be used within another function—such as IF, SUMIF, COUNTIF, SUMIFS, and COUNTIFS."…
-
Hours as a % of a 40 hour work week
What formula would I use if I ask a team member to enter the hours they spent on a project (via form) and then on my sheet I want to convert this to a weekly % allocation? Thank you, Becky
