-
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:…
-
If Or Statement
Hi All - I've been going round and round with this formula and getting the Unparseable error. My guess is that it is really simple, but I'm not finding it. I want invoices that are current, paid or less than 30 days old to return green. I want invoices over 60 days old to return red. Anything else to return yellow. My…
-
"Week of" formula with Friday as start of week
Need the formula below to recognize that the beginning of the week is a Friday. If the "Date of Shift" lands on a Friday, then the "Week of" should be the same date. =IF(WEEKDAY([Date of Shift]@row) = 7, [Date of Shift]@row - 1, [Date of Shift]@row - (WEEKDAY([Date of Shift]@row) + 1)) Below is a screenshot of the formula…
-
Conditional Formula to highlight all dates = Today
I am still working on my same template. Now there are multiple dates that are using formulas. I would like to be able to use a formula within conditional formatting for this range. When I attempted to do this and selected the word "today" it put in today's date. When tomorrow arrives, that will obviously not be helpful.…
-
Can automation reference another grid as a trigger?
Is it possible to create an automation that triggers off a different grid (grid 2) where that information is not copied to grid number one? Example, when grid 2 column NAME says Mike send information via automation from grid one to a Mike via email?
-
Help revising IF statement for Business days (NETWORK DAYS) rather than Calendar Days
Hi all! I have a functional formula (woohoo!). However I have found out I need to transition the formula from calendar days to business days. The screenshot is below the formula. I have hidden the non-relevant columns. Any help is appreciated. =IF(Parent@row = "TRUE", "", IF(AND([Certification Complete]@row <> "Green",…
-
Formula to capture count onto dashboard
I am attempting to create a chart on my dashboard that shows how many reports an individual has completed within the year. I created a new sheet, and use the =countif formula within the cell but keep getting an #UNPARSABLE error. I reference another sheet where the data lives, selecting the column where the assignee is…
-
Conditional Formatting Issue for column formula
Hello all, I am having an issue trying to use what should be 'basic' conditional formatting for percentages in a column in my sheet, where there are no colors being displayed as intended. Green = 55% or below Yellow = 55% - 109% Red = 110% + The column the cond formatting is referencing is using a formula - I wasn't aware…