-
Best formula to return a list of qualifications for card view
Hi Community, So, I am trying to save myself a lot of manual data entry. Ultimately, I am trying to take a spreadsheet that was created in Excel, to capture each persons "qualifications" in a specific field, and get it into card view. I have attached the files of what I am starting with and what I would like to end up…
-
RAG Calculation to highlight Red, Green and Blue balls
I cannot work out how to combine the following arguments into one cell and calculate, i have spend hours trying and getting no where, would appreciate any help. The following will return a red or green to the RAG column and works perfectly : =IF([Baseline Variance]@row <= 0, "Green", IF([Baseline Variance]@row >= 1,…
-
IF VALUE
Is there an easy way to do this? Currently, I look for a match between a cell in Sheet 1 and cells in Sheet 2. If it finds a match, it uses the value in Sheet 2, otherwise it shows "No". This works fine. However, I'd like to add another IF so that if the value in Sheet 2 that results from the match is "Canceled", I want it…
-
IF Statement with nested AND, OR, and a Third Overriding Result
Hi Everyone, Notes40 contains a manually input numeric value that I'm using in a calculation to populate Notes70. Notes69 is a parent of Notes70, with a manual input of either "NA", "N/A", or no input. The result in the Notes70 calculation should display only if Notes69 is NOT "NA" or "N/A". Otherwise, I want Notes70 to…
-
Multiple IF in the formula
Hi all, i need help in the following formula. If [Due Date]394) = current month, return value as Current. If [Due Date]394) < current month, return value as Due. If [Due Date]394) = current month, return value as Not Due. =IF(MONTH([Due Date]394) = (MONTH(TODAY())), "Current"), IF(MONTH([Due Date]394) > (MONTH(TODAY())),…
-
Approval Flow Notification Bug or am I doing something wrong?
Good morning everyone. I have a sheet linked to a request form which based on the info submitted needs to be approved by a number of people. I have 14 approval workflows, based on country of the requestor, the total amount requested, and or reason for request. There are 4 to 5 approvals required based on the type of…
-
Sheet report Countifs - multiple categories by person
Hi We use a metrics sheet to tally the number of design dept. requests (10 types), this then feeds to a dashboard for the Co. to see currents Dept demands. I've been asked to now reflect the number of requests by status (7 types) per design team member (4 staff). I have individual totals, IE David 10, =COUNTIF({Request…
-
At Risk Flag - Checkbox and Date
Hello! I am trying to have an 'at-risk' flag for this following scenario. If the "Onboarding Call Completed date is a date in the past, and the "PIP Finalized" column is not checked, I need the 'PIP At Risk" column to flag. I have floated to different threads but nothing I could put together got me to the solution I was…
-
Month to date formula
Hi, Can anyone please suggest with a "month to date" formula that I can use in my sheet that is set up as shown in the attachment? I have a column that lists down all the dates in the year 2020. I would like to insert the formula in the checkbox column such that if the criteria is month to date criteria is met, the box…
-
We have a worksheet with a number of dates. I would like a formula to automatically calculate a date
We have a worksheet with a number of dates. I would like a formula to automatically calculate a date 6 weeks before a date in anothor cell? Ie. If "FYE Date" is 28.02 or 29.02 then "start date" = "FYE Date" - 6 weeks. Is this possible?