-
Date formula for leap year
Hello All, I am hoping to get some help for the date formulation. My date of manufacture is 04/01/2019 and I want to use 04/01/2019 to add 3 years and minus 90 days from 3 years. There is a leap year in 2020. I was hoping I can get 01/02/2022 (because of the one extra day in 2020); however, it kept populate 01/01/2022. Is…
-
IF Error Add to Formula
Hello All: I would like to ad IFERROR to the Below Formula so when the Stories is 0, I do not get a #DIVIDE Error. =$Stories$11 Represent the Total =$Stories$11 / Stories@row Thanks
-
How to count the number of times a value appears based on multiple criteria in another column?
Hello, I am trying to create a formula that counts the number of times an email appears based on a number of selections made from a drop-down menu. The process is for counting the number of trainings completed per quarter per employee. The trainings are submitted through a form and only one training title can be submitted…
-
MIN Date not working
Hello, I was trying to create a formula to show the MIN date in column on another sheet. I put =MIN({Referenced sheet and column}) and got #invalid column value. Would greatly appreciate the help - seems like it should be a straightforward formula.
-
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…