-
Index/Match trouble with returning text value
My goal here is retrieve the Row 1 values(grey cell color) based on where the match cell (value = 14) in this case falls under. I added a row identical to the column header values to try to get this method to work but if there is a way to retrieve the column header for the top 3 highest values in a row please let know.…
-
Mid Date between 2 dates
Hello, Can anyone help me with a formula to find the mid date between 2 dates. Like what will be the mid date between 1st Jan 2021 and 31st March 2021.
-
How do I prevent a formula from checking an empty row.
I have a formula that checks a box if a name appears on another sheet. However, when there is an empty row the column remains checked. How do I prevent this? In "Previous Student (within last year)" there are check marks when there is no name in the name column. Here is the formula I am using: =IF(COUNTIF({Fall 21 Names},…
-
Is there a way to count the number of CHILDREN in a column?
Hello, I am trying to count the number of CHILDREN I have on a single sheet in my Primary column in order to output the total number of projects we have. My hierarchy in my in my Primary column is "Project Manager" (PARENT) and then "Project Name" (CHILD). I want to count the total number of CHILDREN in that column, but…
-
Replace blank values with 0 but leave non-blank values alone
Hello all, I have a sheet with numerous columns that contain dollar (USD) values. Many of the rows have a blank value in these columns, and I would like to change those blank cells to be 0. I was hoping it would be as simple as highlighting the column and using "Find and Replace" to replace all blank values with 0, but I…
-
How to create an Index Match Formula for multiple sheets?
Hi, I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information. The destination sheet has two columns that it will look at. A "TIDC" column where staff members place a ticket code An "Assigned to" column, which is a contact list…
-
Can you see real time comments in Dynamic View?
I have gotten this question a few times and the problem that we have run into is that when we type the comments in the Dynamic View comment section, we are not able to see it after we hit submit. The only way we know that the comment was saved is choosing another row and come back to prior row, then we are able to see the…
-
Out of Service Formula
Hi Community, I'm attempting to create a formula showing the OOS status of the most recent submission for each asset based on the Asset ID in form submissions. For example, below Asset ID FD-001201 would be considered out of service, however, I'm not sure how to account for it being the most recent submission if there had…
-
Percent complete is showing more 100%
The formula works, but it is still calculating after the finish date is met. How can I stop that from happening? Below is the current formula I am running. =IF(ISBLANK([Estimated Start]@row), 0, (TODAY() - [Estimated Start]@row) / ([Estimated Finish]@row - [Estimated Start]@row)) Thank you,
-
Display RYG based on selection from drop down menu /w 3 choices and IF/OR statements
Hey Trying to select from Column3 dropdown menu (Not Started, In Progress, Completed) to determine Column4 entries as Red (Not Started), Yellow (In Progress), Green (Completed). Not a programmer but tried: - =IF(([Column3], “Not Started”, “Red”), IF(([Column3], “In Progress”, “Yellow”), IF(([Column3] “Completed”, “Green”))…
