-
Help on Or/Contains formula
I am in the need of some help as I am banging my head against the wall trying different formula options here. I wish to grab all characters left of a certain character combination (" -") from a drop-down cell. For instance, I wish to grab "Hosted Event (physical)" from the drop-down cell with "Hosted Event (physical) -…
-
Date validation formula referencing Sheet Summary fields
Hello, I'm trying to update a date validation formula to include a reference to two Sheet Summary fields. The formula seems to be working -- except for the piece that references these Sheet Summary fields (in bold): =IF(OR([Preferred Date*]@row = "09/04/23", [Preferred Date*]@row = "11/23/23", [Preferred Date*]@row =…
-
SUMIFS with Multiple Criteria
Hi all, Trying to SUMIFS with multiple criteria and getting an unparseable error. I need to know the sum of hours by a department for each month. =SUMIFS({Estimated Hours}:{Estimated Hours}, {Sprint}:{Sprint}, input@row, {Department}:{Department}, "Sales")
-
Risk Formula (Red, Yellow, Green)
I am using the formula below to automatically calculate risk. I am using percent complete of a task against time complete off the start and end dates. =IF([%CMPLT]@row >= (NETDAYS(TODAY(), [End Date]@row) / NETDAYS([Start Date]@row, [End Date]@row)), "Green", IF([%CMPLT]@row > 0, "Yellow", "Red")) So if my start and end…
-
Formula If/Then help
I have the following columns Confidence 2023 Calendar Savings I need to have a formula in a third column that calculates the following If confidence = 25 then multiply 2023 Calendar Savings by .25
-
% complete duration
I would like to calculate duration % complete from the actual start and actual end date, Is there a formula to calculate the duration, should be calculated based on hours (24 hours)
-
Formula to change a parent row cell based on the values in the child rows.
Hello. I am trying to create a formula to change the parent cell based on the values in the child cells. The cell values are blank, "Met" or "Unmet". Once all the child rows have the value of "Met" I need the parent row to change to "Met" and if any of the child rows have the value of "Unmet" or "blank" I need the parent…
-
Auto refresh formula fields in a report
When you try to update the value of the cell that will trigger the calculated fields in your Report, it will automatically update on the sheet but it doesn’t reflect in your Report as you have to refresh it before seeing the updated value. Please always automatically refresh the Report to see the updated value of the…
-
How do I subtract "break" time from my Time Tracking Columns?
I'm pretty far along on what I would have thought would be a normal function for a spreadsheet application called "Smart!" Anyway, I need to figure out the last steps in subtracting the break from the total hours worked. It shouldn't be hard as they are one of the following: 0:15; 030; 0:45 & 0:00 or 1:00, whichever that…
-
Error in WEEKDAY formula
I'm struggling with a formula that seems to be broken. I created a timesheet that has a cell that looks at the Auto Date/Time stamp and calls up the weekday. The formula is as follows: =WEEKDAY([Date/Time]129) It works great...unless the timestamp is 5:00PM or later. Then it results in the next day. So if the timestamp is…