-
IF statement with two possible outputs
Hi there, I'm trying to populate a cell/column with a couple scenarios: Column names: "Region/Country", "Wine", "Vintage", and "For copy-paste" If the Region/Country = "Champagne", then the "For copy-paste" cell should populate with Region/Country + Wine + Vintage. If the Region/Country is anything but Champagne, then the…
-
SumIf question
Hey folks. I'm trying to sum the contents of the column (JobSite Hours) if a certain contact is selected on an adjacent column (Special Conditions). The special conditions column is in fact set up as a contact. my formula works if only one contact is chosen, but the special conditions column is a multi select cell. If…
-
Max Collect latest date based on 2 criteria
Hello, I am trying to get the latest date to populate by using MAX and COLLECT based off of the Zone being Ambient, and the Floors checkbox being checked. This is what I currently have: =MAX(COLLECT({When}, {Where}, Zone@row, {Floors}, =1)) Here is where I am pulling the data from: And here is where I am hoping to have the…
-
=ISNUMBER
Hi! I am trying to figure out the proper way to incorporate =ISNUMBER into my formula. I keep getting errors and can't figure out how quite to frame it in. I have a flag but I do not want it to flag blanks or text. I only want to flag duplicate numbers. =IF(COUNTIFS([Site ID]:[Site ID], [Site ID]@row) + COUNTIFS([Device…
-
Problems with Sumif formula
Hi, I'm trying to work out what's wrong with this formula. Any help appreciated. Thanks =SUMIF({Plan Metrics Range 2},(HAS(@CELL),[Work Stream Members]@row),{Plan Metrics Range 1}) Plan Metrics Range 2 is a column in a calculations sheet which has a list of team members across multiple teams (contact list) Work Stream…
-
Cash flow from a Fee Calculator - Calculate assumed Monthly Rate
I've built out a Fee Calculator that assists our team in articulating the %allocation of a team member against a Phase of a project for upcoming projects. You'll see from the screenshot below, that the example Project runs from 4 April 2022 through to 25 November 2022 and that the Allocation reflects time against a…
-
IF & Vlookup
Hi there, I am trying to complete a VLOOKUP with an IF Statement but its returning a blank despite data being available in the cross-reference sheet =IF([Ex Works]@row = "Yes"; VLOOKUP([Product Number & Name]@row; {Item Master Range 1}; 3; VLOOKUP([Product Number & Name]@row; {Item Master Range 1}; 2))) What am I doing…
-
Pull data from one column, based on two other column criteria
Hello, I'm trying to get the data from the 3rd column into a Sheet Summary, based on the current week and year. Currently as of writing this week is 27, and the year is 2022, so I'm hoping to get the value of zero, and use that in a formula for a sheet summary. I thought this equation might work: `=INDEX([WEEK…
-
RYGB Formula
Can you help me create a formula for the following? If Assessment Sent is blank = Red If Assessment Sent is a date and Complete is blank = Yellow If Complete is a date = Green
-
Fill a column with a value based on the date of another column
I have a "Status" column where users can select "Completed" from a drop down list. There is another column called "Due Date" that already has value plus a third column called "Timeliness". What I would like is...when a user select Completed on the Status column, it will enter "Late" in the "Timeliness" column if the…
