-
If not blank formula for 2 column options + result as a sum formula or 0
Hello, I am trying to make a formula where if "Drug Selected/ Wrong drug (0)" is not blank or "Patient profile / wrong patient (0)" is not blank then the return value is 0 and if it is blank then there is a formula where it adds up the value remaining columns. Would anyone be able to help me with making this formula? Thank…
-
5 nested IF arguments
=IF([#1 Date of Review]@row = [Latest Review Date]@row, [#1 Time]@row, IF([#2 Date of Review]@row = [Latest Review Date]@row, [#2 Time]@row, IF([#3 Date of Review]@row = [Latest Review Date]@row, [#3 Time]@row, IF([#4 Date of Review]@row = [Latest Review Date]@row, [#4 Time]@row), IF([#5 Date of Review]@row = [Latest…
-
Automate Parent Status Rollup based on Descendants' statuses
Hi folks — has anyone figured out how to enable users to update statuses manually for child rows, and then have the parent rows’ status update automatically? There are multiple levels of hierarchy. For example, I have three statuses that a child row can be; In Progress, Not Started, Completed. I have figured out the…
-
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:
-
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…
-
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
