-
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 =…
-
Linking the same date from one cell to a second cell on same sheet
Hi Gang, I am having a hard time trying to use the date entered in one cell to another cell in the same row from the same sheet. The column I want as the target is RECEIPT DATE and the column for the duplicate date is START DATE. I have tried =[RECEIPT DATE]@Row but it didn't return anything at all. Thanks for the support,…
-
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: If Preparer Status is "Complete" OR Preparer Due Date is earlier than today AND Preparer Status is NOT "Complete", then put a green circle If Preparer Status has a status of…
-
Checkmark Column Formula
Afternoon, I have tried every formula in the book to count all check marked boxes within a column. Can anyone just write the formula that works for them? This is the formula I am trying to make work- =COUNTIFS([Construction Complete- Not Submitted]2:[Construction Complete- Not Submitted]254, 1)
-
Using a Risk flag
I want the flag if the date is past due, but it's also giving me a flag if the end date is blank. what am I missing here? I tried to add another NOT statement and ISBLANK, but then was just getting errors. =IF(AND([End Date]4 < TODAY(), NOT(Status4 = "Complete")), 1, 0)
-
Countif formula, I want to count if anything is in a column
I can't figure out how to count a column if there is anything entered into the column, can anyone help?
-
Multiple IF statements
Hi Team, I tried to follow the solution mentioned "regarding combining multiple IF statements", I get an Unparseable error. My formula: =IF([PM Effectiveness]@row=🤩 Strongly Agree,"5",IF([PM Effectiveness]@row=🙂 Agreed,"4",IF([PM Effectiveness]@row=😐 Neutral,"3",IF([PM Effectiveness]@row=😞 Disagree,"2",IF([PM…