-
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…
-
Update Requests
I would like to have a update request go out when the value of a cell in a column goes bellow the number in a cell in another column in the same row, im wondering if this is possible. I cant find a way to do so. the catch is the numbers will be different for every row so i cant use one specific number which is the only…
-
Sheets to Reports - Possible bug discovered
Just sharing some items I discovered. I have a master sheet and a report that feeds from that master sheet. I had a specific column set up as text/number data type with a formula in there to compute a "Yes" or "No". Those "Yes" and "No" fields were pulling into the report but not editable (since you can't edit formulas).…