-
Percentage Increase/Decrease
Hi there, I've looked at some other answers in the community but none seem to work for me. I'm trying to determine the % increase or decrease of values Year Over Year. Here's an example: THIS YEAR, we have a sheet that shows $125,000 in revenue. This time last year on a separate sheet, we showed $225,000. How do I create a…
-
RIGHT + FIND with LEFT + FIND
Hi, So I can run automations to notify individuals, I have a column that is a contact list. For data reporting purposes, I need to upload the names into an API in a (last_name, first_name) format. To get around this, I have concocted a two-step process: Write a function in a cell to pull back (first_name last_name) Write…
-
COUNTIFS formula to return # of dates within a specified month
I reeeeeally tried to help myself with this one and I did come across a few other similar posts on month and date range formulas, but I keep getting invalid operation or unparseable errors with everything that I try. Above is the start of my formula. Range 2 is a date column. How can I return the number of dates that fall…
-
IF Statement Help
I'm trying to create a formula that looks at the [New Cost*]" column and if it's blank to leave it blank but it its not blank then I want it to run this calculation and return the number :[New Cost*]@row - [*Original Cost]@row) * [*Qty.]@row I'm new to formulas and can't quite figure it out Thank you for your help in…
-
Counting 2 Columns Status and Date
Hello, Looking to see what the formula would look like for this. I have 2 columns, one shows projects on time and late the other shows the end date of the project. I have identified the formula should be =COUNTIFS( but I am not sure how to form the formula to pick individual months to show how many project showed up On…
-
supprimer le 0 dans cellule
Bonjour à tous, Je m' appel Sébastien et malheureusement je ne parle pas anglais. J'ai un problème de formule dans une cellule. Je voudrais faire une addition et si la cellule de quantité est vide dans la cellule de destination je voudrais que le 0 ne soit plus afficher. En vous remerciant. Sébastien
-
VLookup Issues
Problem: While I am able to input the VLOOKUP formula correctly, I having an issue with it returning correct data. I am using a form to track attendance. The same form inputs dates from different lab types but creates a row with each entry. Each different lab date creates a new row as designed. I am trying to move the data…
-
formula building up lead scorecards
Dear all, I have a sheet "lead management" with columns like "number employees", "sector", "region" and many others - all of them as dropdown lists Now, I want to create another sheet with the score criteria and score values f.e. column "number employees" // column "region" zero employees = score value "-10 // region north…
-
Nested IF statement with VLookup Formula
Hello, I have two sheets that contain data from employee responses to different questions. Employees answer at least one question per day. If an employee answers the question on sheet 1, I need that value, if they dont have a response on that sheet, I need to look and see if there is an answer is on a different sheet. I…
-
Estimate Date Planned against the target date
I need to calculate the planned date against the Go-Live date for each column. The dates are above the columns that should be prior to the Go-Live Target which is 10/31/22. I need to make the actual columns cells yellow for 3 dates against the planned date, red at the planned date. If a date is entered in actual column,…
