-
Simple Planned vs Actual Completion Formula
Hi all, Trying to solve a quite simple problem with some most of the work already done. I'm trying to show in a dashboard the percentage of tasks which should have been completed based on planned finish, vs the actual tasks completed. I have a "Planned Finish" column, a "Status" and "Actual Completion Date" column. I…
-
Can I link 2 sheets with a formula that feeds many date columns?
Dear All, would you please advise if this is possible? if yes, would that be a combination of JOIN/ COLLECT/ IF / AND? If no, is there a way around it? I need the dates in these 10 columns: to feed into these 2 date columns: The condition is that Discovery Start Date has to feed into Phase Start Date when the activity is…
-
Pulling Parent Data without Grandparent in a column with a column formula
I would like to pull data from a parent row into the children but with a column formula it goes back to the grandparent, how do I exclude the grandparent data?
-
Struggling with COUNTIFS and CONTAINS
Hello! I have read through a bunch of questions about COUNTIF and CONTAINS formula but none seem to be working for me. I have a metric sheet in which I need to count the number of projects in a particular status for a particular business unit. The business unit field on the source sheet is a multi-select field, projects…
-
Multiselect column for each row return all associated matches from another sheet.
I have a convoluted problem, index match only works for single input, and I have a multiple select column for business unit with up to 6 options resulting in up to 6 individuals needing to populate the contact column from sheet 2 in the project tracker and unlike excel I cannot use wild cards. Sheet 1 Project Tracker sheet…
-
COUNTIFS not picking up some values - Name / Email
I am trying to count the number of Submissions by Submitter. The Submitter uses a Form to enter a line on the Sheet. They identify themselves by email address on the Form. The COUNTIFS formula I'm using at first seemed to get hung up on whether the form displayed a name (for the contact) or the email address. I've updated…
-
Formula guidance
Hi guys! I am trying to help fix a sheet that was built by someone else, and that person is no longer working for the company. They have a Dashboard that pulls data from a metrics sheet, that pulls data from a main data sheet. It looks to me like the sheet was moved or something, as it appears to have disconnected from the…
-
Need help dialing in a grading formula [percentage to letter (100 to A+, 80 to B-, etc.)]
Hey all, This formula works most of the time, but it won't show the letter grade all the time, I think when its close to an in-between number. Any help making it function 100% of the time and not show an empty cell would be appreciated =IF([Week 04/01 Results]5 > 0.96, "A+", IF(AND([Week 04/01 Results]5 >= 0.93, [Week…
-
How can I create a formula to list names that haven't been added (cross sheet)
I am trying to have a summary list all of the names that are on one source sheet but are not populated in destination sheet. I am creating a time entry process for my company and would like a summary section to show who has not yet submitted time based on the list from another sheet. So if Sanchez has not entered their…
-
Is there a way to set up fiscal months other than a giant IF statement
We have our fiscal months that always end on a Saturday. So some months are Fiscal Month April 2024 will be from 4/1 - 5/3 = April, May is 5/4-5/31, etc. I made a Fiscal Months sheet with start date and end date for 3 years. I now want to cross reference that so when I import by revenue, bookings, etc. it will take the…