-
"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…
-
Need formula to show row ID/link in a cell
Hey team, trying to find a way to populate a row id or row link in the cell. Is it possible?
-
Formula to track training by hours and minutes not days
We need to track all training by hours and minutes, not days, and I can't find a solution to be able to calculate this with a formula. Anyone able to help? Thanks!
-
#INVALID VALUE with date formula
Hi there, I have a sheet with 3 date columns - one for inputting the date when a QC investigation was opened, one for calculating a deadline for QC which is 1 month from the opening date, and one for calculating a deadline for QA which is 1 month plus 15 days from the opening date. In certain instances the formulae are…
-
What's your Best Error Checking Column Using Formula?
I have discovered multiple ways to create a error checking column that looks in all columns to see if there's a broken formula somewhere. However, all the ways I have found aren't very elegant and don't provide the type of details I want. Example: =IF(ISERROR([First Column in Sheet]@row:[Last Column in Sheet]@row), 1) This…
