-
Check box if matching value in other sheet
Hi All, I am attempting to write a formula that would check a box if a value is present in another sheet, and I can't figure out exactly how to write it. I am thinking it would be a combination of IF, INDEX, and MATCH. I have two sheets, both of which have a column called "Protocol ID." I want to check a box if the…
-
Lock the cells based on the duplicates
Hello Experts, I have 3 COMMENTS row duplicated and 1st COMMENTS row is having translation captured for the 3 language headers. However, there is 2nd and 3rd COMMENTS row. I have already enabled duplicate logic to highlight the row in YELLOW color, so the 2nd COMMENT row is highlighting in YELLOW. Is there any possibility,…
-
Need a formula that evaluates multiple cells for data
I need a formula that looks in multiple cells for a value, when it finds a value, do a lookup to find the translated value. I have a sheet that is gathering data in different languages, and we need them all to be translated to English. Below is the snip it of the sheet. So if the form is in English, it will return the…
-
How to add varying months to varying dates?
I am really having trouble getting a formula to work here. I've gone through a number of support articles, but I'm just missing something. I want a formula that looks at Date Contract Executed and it adds Months Until Expiration to produce a new Date of Expiration. I've got my date columns as dates and the middle column as…
-
Formula to populate just the first row of data in another sheet
I'm trying to write a formula to populate data from one sheet to another but I only want the top row of data to populate and then update when the 1st row changes. I have a Submission Form sheet that gather data from a form, when a new form is submitted it will be at the top of the sheet. I want that top row of data to auto…
-
Check for Matching Values on Another Sheet
OK, so I have two columns on multiple sheets, ESTIMATED PROJECT SIZE and ACTUAL PROJECT SIZE. On the sheet I'm working in, I have a column called PROJECT SIZE DIFFERENCE. Essentially, I want to write a formula in my current sheet that checks both columns on one of the other sheets (one at a time, so I'll have to write…
-
How if a box is checked it any point in the process it will mark it checked for that section
I have sheet that has many items on one that all have a similar process. If one is marked sold at any point (any child step) it will check all the sold for that particualr parent and children. This will stop the notification for that particular item. I do not want it to check the boxes for the whole column because it will…
-
CONTAINS formula with contact cell
Hi everyone, I'm trying to map all tasks and collaborations for each employee to help them manage their workload. For collaborations, multiple employees can be tagged in a single cell. My first attempt was to use a simple IF(cell = "NAME OF THE EMPLOYEE", 1, 0). This works only when one employee is tagged in the cell.…
-
Create a sheet that lists all working days in the date column
I am creating a template for a daily log for our job sites. I want to find a quick way to fill in our working days into the rows so I'm not manually typing or clicking and dragging and deleting every weekend day, does anyone have a formula for making this happen?
-
Consolidate Columns in a Trendline Report
Context: I have created a trendline report that counts the number of projects started each month. I've done so by building out three separate columns that determine the month and year so that I can then plot it on a trendline graph with a 2024/2025 series. The Chart: How the data is organized: Month Formula:…