-
Why am I get an error when I added IFERROR to formula:
=IFERROR(YEAR([Current Charleys GO]@row) - YEAR([Walmart Revised GO date from 7/8]@row)) * 12 + IFERROR(MONTH([Current Charleys GO]@row) - MONTH([Walmart Revised GO date from 7/8]@row)), "")
-
Invalid Data Type when Date column empty
Hi all, I'm using the formula below to calculate the NETWORKDAYS between the date an invoice was submitted until it is paid, if it has not been paid it calculates the NETWORKDAYS with TODAY. The formula is working, however, I'm getting an error on every row that does not have a date sent for payment yet. Is there a way to…
-
Counting Completed Tasks For Dashboard Report
On the project metrics sheet used for dashboard reporting, I need to count the number of times a particular task has been marked as completed using a checkbox. Here is a screenshot of what I am trying to count (see green highlight). Here is what this looks like on the project metrics sheet including the formula that keeps…
-
Very simple stock take...
Good morning! I have a simple stock take i'm trying to sort out for daily use, ideally i'd like to input a value into the IN column and this would automatically add it to the value already in-stock and again for the OUT column id like it to subtract from the value in stock. Is there a way to do this? Many thanks.
-
Formula to add a number in a cell based on other figures
Hi hoping for any help I can get on this. Using the image as a reference. Im trying to make [Length score] show a number between 1-4. the scenario being if the length is 30 days or less it equals 1 and between 30-90 it would show a 2, between 90-150 show a 3 and between 150-365 show a 4. Would love any help on this people…
-
Using TODAY() in a Sheet Summary
I am trying to get a sheet summary formula to report a cell based no todays date. I tried the following formula (and a few similar variations) with no luck. What am i doing wrong? should i be going the vlook up route? Thanks! =IF(Date:Date = TODAY(), [Total Completed C-Boxes]@row,"")
-
Symbols Column not Displaying Symbols per Formula
I have this JOIN statement that works but it does not show the symbols setup for that column. Any idea why? Your help is appreciated in advance! =JOIN([Previous Week Trend]27 + " " + [Previous Week Trend]30) returns Unchanged Unchanged
-
Pull First Name and last Name from email id
Hi team, All our comp email id follow the same format as firstname.lastname@amplity.com So, can you please confirm the formulae on how gaurav.chauhan@amplity.com would convert to Gaurav Chauhan Also, would be advisable if the first letters can be uppercased as well
-
COUNTIFS with OR
I am trying to solve for a formula to countifs all conditions, except for one that I want to count if either/or: =COUNTIFS({HR Projects - Project Stage}, Metrics16, {HR Projects - PMO Must-Do}, 1, {Range 4}, 0, (OR{HR Projects - PMO Range 7}, "Inclusion & Diversity", "Employee Experience") Thank you!
-
AVERAGEIF with an AND
I'm trying to find the average lead time for completed projects that were started this year and I'm having an awful time. Full disclosure, I'm not great a writing formulas. I can get the average lead time for completed projects. This works just fine: =AVERAGEIF({Status}, CONTAINS("complete", @cell), {Lead Time}) And I can…