-
I need help with a formula that references one fixed date
I want to create a formula with a fixed date at the top of the sheet. There are subtasks with actions that must be completed a specific number of days before this event. Each row of tasks corresponds to a different timeline. Currently, my formula is =[Date of Event]@row - [Days Before Event]@row. However, this necessitates…
-
Trouble Coming Up with a Countif Formula...
I am trying to figure out a proper formula to count two criteria within one column and a specific date in another column and feel like I’m tried every one except the right now so far and whether I’d need an AND or OR option within the formula or something else. The columns in play are below: Call Status Column Left Message…
-
Create a formula using the outcome of another formula in a different column
Basically, I want to know all the Issues for the 4 stars groups. Im using this formula to count the multiple values in a column - =COUNTM([Issue]:[Issue]) But I want to say, all Colorado groups have (this amount of issues) which is the result of the previous formula.
-
I'm trying the CONTAINS and HAS formula and neither seem to work
I'm trying to count the number of times a word appears within a column range on another sheet; however, the cells I'm referencing have a dropdown so there may be more than 1 value per cell. I may be entering the formula wrong or not entering the right formula.
-
fixing this nested IF , INDEX/MATCH formula
I am having issues with getting this formula to work: =IF([Latest comment]:[Latest comment] <> "", INDEX([Latest comment]:[Latest comment], MATCH(MAX([Notes Last Modified Date - Helper]:[Notes Last Modified Date - Helper]), [Notes Last Modified Date - Helper]:[Notes Last Modified Date - Helper]), 1), 0) In the Notes last…
-
How to have the In Progress status be green when there are no start/end dates
Hello! I am trying to have the have the status show as green when something is in progress, even if it doesn't have a start or end date. I only want it to turn yellow or green when there are end dates involved. Here is my current formula: =IF(ISBLANK(Complete@row), "", IF(Complete@row = "Not Started", "Gray",…
-
Conditional formatting
Hello, How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red? Is that possible?
-
Sheet Formula
Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying to get it to count all the dates in the column, but I also want to use to the formula to count all the rows with that same…
-
IF HAS Formula to Return Email in Contact Field
Hi, I have a sheet that includes a multiselect contact field with RA names (On-Site RA(s))and a second contact field (Manager). When joesmith@email.com is one of the emails in the On-Site RA(s) field, I want maryjones@email.com returned in the Manager field. I have added the IF HAS formula you see in the example in the…
-
Mapping data within a hierarchy
Hello, I hope you are well. I'm trying to find a way to collect information within a hierarchy on a sheet. I need to gather the last date for a column within a level of the hierarchy and display this date in the parent cell of this hierarchy, regardless of whether new rows are added during the project's development. The…
