-
Calendar View - Adding Descriptions and Details
Hello, Is there a way to change the view of the calendar entries to include the details in that card? Example: Can the calendar entry in green say "Stephanie Admin" (listed in the activity) instead of only the employee name?
-
Count IF formula that meets multiple criteria.
I am looking to get an accurate count of someone’s workload. I want to count if a specific person’s workload meets multiple stage criterion such as “Execution” and “Planning” The Support Required column is a contact list. The Stage column in a dropdown list. I am pulling this information into a separate sheet hence the {}…
-
formula for status RYG change
trying to write a formula for the RYG dot to change in Status column: IF OpenDeliverables is <=0, Green.. & IF OpenDeliverables is > 0 AND DATE is within 30 days, then yellow, within 14 days or paste DATE, then RED
-
RAID Log Calculations for Dashboard Display
Hi, I am trying to update my dashboard with the RAID log status of Open, In Progress, and Complete. I have the formula =COUNTIF([{IS RAID Log Horizon Integration Range 3}, "Open") Linking it to the Raid log Status field which is range 3 but I am getting an unparseable error. Any advice is greatly appreciated. Thanks, Tracy
-
Multiple IF Statements
Can we do multiple IF statements? I've tried to use IF and also OR to complete the function I'm trying to do and nothing seems to work. I want my Status column, "Not Started", "In Progress", and "Completed" to be based off of the % indicated in the % Completed column so I don't have to remember to change the status when…
-
Formula to check box if cell contains Date OR Text
I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…
-
How can I calculate the total days of a column when another column meets a criterion?
Hi everyone, I need help creating a formula that collects the total days from the date a request is inputted to the day it changes from "Pending" to "Approved". Dates are registered in the column "Date Initiated" Status is registered in the column "Review" I created a "Today's Date" column to subtract the requested date…
-
COLLECT with an OR criteria
I have a COLLECT statement with multiple criterias, one being and involving an OR. In the below formula I have a Discipline column where I want to bring back Reading or Literature for a particular year. =JOIN(COLLECT({SA Grid: ELA}, {SA Grid: Go/NoGo}, ="[X]", {SA Grid: Year}, =Year@row, {SA Grid: Discipline},…
-
Percentage Formula based on Stage
Hello, I have a process that is 11 stages long (stage 1, stage 2, ...) and I want to write a formula for percent complete based on the current stage. Each stage will be equal in percent value. There will be many clients items going through this process, 1 line per client. There will be a column with the clients name, then…
-
Need a fix to formula to verify with system date and return a value
With the current formula i'm able to verify system date with the value started with two characters but not more than 2 Characters. Can some one please help to fix this. =IFERROR(IF(VALUE(MID(SUBSTITUTE(Source@row, " ", ""), 3, 2)) > VALUE(RIGHT(YEAR(TODAY()), 2)), "N/A", IF(AND(VALUE(MID(SUBSTITUTE(Source@row, " ", ""), 3,…
