-
formula help
i have a checkbox column that registers a check mark when an amount is over $100. The sheet has a form for collecting data. i put in a the formulaย =IF(Amount20 > 100, 1, 0) in the checkbox cell. Only when data comes in from the form, it puts new data at the bottom of the sheet below the formula. how do i get the formula toโฆ
-
Auto updating a status
Hi, I am looking for some help with a formula please? I have a scheduled date which is static, Column name "1st Scheduled" i then have a completed date, Column name "Completed date" I am trying to have the status column update to "Overdue" if no date is entered in the "Completed date" and today is past the "1st Scheduled"โฆ
-
Nested If Statement with If/And in it
I'm having trouble adding If/And to a nested IF statement. Hoping someone might be able to spot where I'm going wrong. What I'm trying to do is automate a red, yellow, green, blue column. The last criteria combine criteria in two separate fields. Thank you! =IF([Approval Status]1 = "Denied", "Red", IF([Approval Status]1 =โฆ
-
VLOOKUP for multiple options influencing Gantt chart
I have a sheet that uses Gantt chart data to show assignments on a calendar. The persons assigned are all in a "Name" column that is a drop down with all the employee names on them. Next to that are start and end date columns that then show a bar range in calendar view. The employee's name will only appear in the bar inโฆ
-
VLookup or not
Im working on a scrum dashboard and want to show the actual sprint name. The Sprint Name (e.g. Sprint 01, Sprint 02...) is in the primary column at Level 2 (task at Level 3 and Release at Level 1). I have a column with the status ("Do", "Doing", "Done") and only one Sprint can be in the "Doing" status. On my metrics sheetโฆ
-
workday calculation with if conditions
Hi, I'm trying to add a workday function to my current calculation. I already use if condition in the cell. Here's what I have. If location is Riverside, then add 3 days to ETA. If location is Memphis, then add 5 days to ETA. IFERROR(IF(Location1 = "RIVERSIDE", ETA1 + 3, IF(Location1 = "MEMPHIS", ETA1 + 5)), 0) However, Iโฆ
-
Using COUNTIF to determine quantity of rows with number not ending is 000
ย Hello, I'm trying to setup a "Line Quantity" of children where the primary column contains a 5 digit number. These numbers indicate line items of a purchaseย order and have a hierarchy themselves. The numbers that are considered the parent end in 000 with all the items that are children end in various numbers in incrementsโฆ
-
SUMIF
Hi, I'd like a formula to calculate the below SUM the leave days Request(Column Number of Days) against the employee(Name Column) if Approved(Manager Column) and Approved(EXCO Column). If either one of them are not approved then don't SUM the leave days. This is what i have so far but cant seem to get it to work.โฆ
-
Sumif across Children and Grand Children
Dear Community, I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value. Here areย the formulas I have been trying: SUMIF($[Payment Status]5:$[Payment Status]50), "Received", [2019 Wk 02]5:[2019 Wk 02]50)) => result to #UNPARSEABLE SUMIF(CHILDREN($[Payment Status]27),โฆ
-
Nested IF and
I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine: =IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")โฆ