-
Can I only show the year from the date in another column
I just want the year from [Completed Date] but not able to figure it out.
-
Formula for lights
Hi all, I have a sheet that contains fields for "Preparer Due Date" and "Preparer Status" and am trying to add in the following logic to a formula: Blue = completed Green = task not started or in process that are due more than 3 days away Yellow = task not started or in process that are due within the next 3 days Gray =…
-
Grouping
I have a tracker I started from a Project template which I am pulling information from into a Report and for some reason the column I want to group by does not appear as an option for grouping. What is the reason for this?
-
How do you count the number of times a drop down item is selected in multiselect column?
We have a sheet with a column that allows multiselect of the drop down options. We need to count how many times an item has been selected but HAS only works if they select just the one option and CONTAINS grabs options that happen to appear inside other options. For example: Using CONTAINS({range},"apple") with a list that…
-
Check Mark Row
Question- I have 3 check marks within a row. My goal is to figure out a way to have only one of those check marks "checked" at any given time, not multiple. So if one is checked in one column and i check another box in another column then it will remove the existing check mark in the other column. Anyone?
-
Perform operations @row then SUM together
Hello All, I am trying to right a simplified formula to do a complicated task and having difficulty. Below is the formula in question. I am trying to SUM up all volumes of some buffers that use a specific lot of 3M KCL. I also created a helper column with a factor to divide the total by based on which buffer is using the…
-
Using GYR symbol for status nested if's
Hello, Does anyone know how I can use the GYR symbols in a nested if condition? I am using three columns, the last one using the symbol to reflect the status. Here is my logic: If column A has no text, show in column C nothing or "". If Column A has "text" AND in column B has text, show in column C a green dot. If column A…
-
How to Setup A Date Formula Based on a Conditional Statement
I have a date column for noting when someone's contracted employment will end. I'd like to create a formula to reference that date, subtract 180 days from it if their appointment term is "Limited" else the reminder date will be 90 days before the end date. I plan to use this reminder date for a workflow to alert someone.…
-
Date Visibility Logic Check
I have 3 dates (Calc, Planned and Actual). I want a logical function to check and pick the most accurate during the project lifecycle. It starts with a Calculated date and then Planned is updated as the proposals come in. As the vendor prepares to mobile we shift to an Actual Date. I can do 2 of the 3 but can't get that…
-
Formula for Lights
Hi all, I have a sheet that contains fields for "Preparer Due Date" and "Preparer Status" and am trying to add in the following logic to a formula: Blue = completed Green = task not started or in process that are due more than 3 days away Yellow = task not started or in process that are due within the next 3 days Red =…