-
Edate formula
I want to calculate the contract expiry date based on the current contract term. If the day of start date <=15, the expiry date should be the last day of the previous month if the day of start date is the expiry date should be the last day of the current month any help would be great thank you
-
Sumifs, referencing another sheet with two conditions
I am trying to add numbers based on 2 conditions. I am referencing another sheet. I am using the following formula: =SUMIFS({FY21 AA AMER Budget US$}, {FY21 AA AMER Quarter}, contains "2021",[{FY21 AA AMER Marketing Cost Type}, contains "Content"]) I want to add the budget for AA AMER if the following two conditions are…
-
Trailing 12 weeks/months style report
I'm looking to create sheet that will roll up data for a trailing time period. I can collect the data easily enough, but of course, the data changes over time. Is there a way to collect the data, then freeze it and collect new data in a new cell? I don't have a problem pre-building the sheet with all of the future dates,…
-
Need to average a range within a certain month
I am trying to average a column that has its own set criteria and calculating it with in a month. I am separately doing these two formulas but now want to combine it. My first formula:. =IFERROR(AVG(COLLECT({time in days}, {hospital specialty}, "Acute Care", {job type}, <>"PCT")), "") This gives me an average time to…
-
How do I count cells that include a value and not just cells that only have a specific value in it?
I'm trying to count the amount of cells that have a value of "keys" included in it, but it's only giving me the cells that specifically only contain "keys". I want every cell that contains "keys" within any portion of it. Below is the function I've used. =COUNTIFS([Key/ Swipe/ Code Request]:[Key/ Swipe/ Code Request],…
-
What is the best way to set up a multiple entry item list/field within a form?
I'm not sure I worded that my question correctly, but I am trying to create a form at the moment that, in addition to several other questions/fields, asks the user to submit any income/deduction items not already set up and for each entry to give the EE Name, EE #, EE Type, Income/Deduction Name & Amount. Is there a way to…
-
SUM of Only Parents in Budget Sheet
Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!
-
Calculating/adding anniversaries with date functions
Good morning, hoping someone can help out with this. I'm trying to create a formula using hire date and today's date to calculate the number of years working for a company. For example, if someone was hired October 12, 2019, I would like to have a "years with company" automate to "2" and send a notification to my e-mail.…
-
CountIFS with "OR" "AND"
Hello experts! I'm using these formulas for my dashboard, I have the formula working that will give me the total tasks for "Web/IT" and "IT" as the following: =COUNTIFS(RESOURCE6:RESOURCE152, OR(@cell = "Web/IT", @cell = "IT")) … the total was 6 Now I want to then calculate out of those total tasks, which are check as…
-
How to link 2 cells in different worksheets?
Hi, Trying to figure out on what formula or function can I use to link 2 cells in different worksheets. Goal is to have the other cell auto update once a value is entered in a cell in a different sheet. The date type is number. Looking for any suggestions.