-
How can I change this formula to exclude holidays?
I have set up a project status report to automate expected deadline dates for certain project deadlines. My current formula excludes the weekends, but not holidays. What can I change/add to this formula to do so? =IFERROR(WORKDAY([CD Kickoff (E)]@row, +1), "") Also, if I need to have the dates counted by 4 weeks vs days…
-
How can I get the Summarize function in report to use a standard unit?
I am writing a report, and the base data gives % of a person's effort. For some reason, when I sum the totals for a category, some of the groups give a whole number, and others give a % value. In fact, it would be great to sum to a whole number, like the row for Total and the row for Sponsored, since 100% indeed equals 1.0…
-
Help with formula: return value from cell in same column but different row if row criteria is met
Hi, I am trying to figure out how to write a formula to return a value from a DIFFERENT ROW but SAME COLUMN, when a row criteria is met. I can't figure out how to make it work and I am hoping someone can help! Here is what I am trying to do: in [another sheet], if the date in [row] is [>=Today(+15)] return value in [field]…
-
Autopopulating a job number
I have set up a sheet that will house our jobs. It has been requested that each job have its own row, nestled under the customer's name. Our job numbers are derived by using the customer number, year, and job number for the year. For instance, the first job of 2024 for Customer A with a customer number of 1000 would have a…
-
INDEX/MATCH Partial Match
I am trying to pull the tech level for a hearing aid based on a master list. The issue is that my source sheet has a simplified name of the hearing aid that is on the sheet I need a the tech level. I've tried multiple variations of INDEX MATCH and COLLECT and am not getting it to pull. Formula Sheet: Source Sheet:
-
Formula Help
If I want to compare column 2 of Sheet D to column 2 in Sheet F, and return the value from column 1 in Sheet F to column 1 in Sheet D if 2D and 2F are equal, and not return anything if they are not equal, how would I put that in a formula? I think it's a vlookup but my formula didn't work.
-
Sum a column associate with children
I have the following layout, and I am trying to sum the "Ordered QTY" column for all children within each parent in a helper column so I can verify that amount with the parent "Ordered QTY". Any help would be appreciated and thank you very much…
-
Reporting & Metrics
Typically we try to use a report to update our Hypercare Ticket Log. This strategy helps us maintain a clean log and keeps the noise down. What we are finding though is though all members have "Editor" rights in the report, they are not able to create filters or sort the report when they are working. The report needs to be…
-
Append cell value with previous value and new value from another cell
How do we append cell value with existing data.? for example. column source and target. target = target + source. so every value entered in source it should be appended to target with already existing value in target. any idea or formula , please help. thanks
-
How to use predecessors to auto update Part Numbers?
For my use case, I have a version of a product that only updates when it changes on the next version. So for example say I have an assembly that has 3 parts in it. Lets say V1 and V2 of this assembly are identical except 1 item is different so has a different number: V1: 001 [Input] 002 [Input] 003 [Input] V2: 001…