-
Need to Figure out # of days each emplyee is on leave in a given month
Hi Everyone, I'm working on a work days calculation for a given month, for that I need to calculate the leave days for a given month. Below is my grid. Orage colors columns is in different sheet - Leave requests are updated here and green color columns is in different sheet - Need to figure out total # of days on leave in…
-
AVG Collect Formula Help
I am looking to add to the formula so that if {APD CI Tracker Range 5}, ="Pilot/ Implemented" the Dashboard reads "Pilot" OR if {APD CI Tracker Range 5}, ="Monitor/ Check" the dashboard reads "Monitor" and if {APD CI Tracker Range 5} is not Working, Pilot/ Implemented, or Monitor/ Check the Dashboard reads 0 Current…
-
Prioritize by available date
I have a sheet that has multiple dates on a row, but not all will be known at the same time. I’m looking for a function or a way to provide the current best estimated date by priority. Basically, if there is a date in this column, use it, if not, use this other column, and if nothing is in either, use the date from this…
-
Can an automation action copy data from one cell to another in the same sheet?
Hello, everyone! I am helping my boss with a new template to manage our projects. I need an automation that copies data from one cell to another within the same row based on two conditions. Without more context this will sound confusing, but I will try my best to explain. If one column is not blank, and the other column is…
-
Need to remove leading zeros
I have a column that represents 'Store #'. Store #'s are 4 digits, i.e., 0001 or 0010 or 0100 or 1000 This becomes a bit of an issue when sorting the column. I am creating a helper row for purposes of sorting and want to remove the LEADING zeros, however, am having trouble figuring out how to accomplish this. Thoughts?
-
VLOOKUP or INDEX MATCH Referencing Another Sheet
I would like to pull "Type" from a different sheet by matching the Project #. I've used both INDEX MATCH and VLOOKUP formulas which has worked well! Here are the formulas: =INDEX({Program Intake Form Range 1}, MATCH([Project #]#, {Program Intake Form Range 2}, 0)) =VLOOKUP([Project #]#, {Program Intake Form Range 2}, 5,…
-
Display a Result in Percent and Division
Hello, I currently have a sheet that counts a quantity of total on time (YTD) and total overall, referenced from another sheet. And then I have another column that takes this two values to give me a percentage. I have a table that shows me the percentage based per month, you can see it the upper table), the second table is…
-
Formula help
Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market delivered in a specific month. so all type A, from Jazz AT, in April. Thanks in advance Katie
-
Formula help
hey guys, i need some help creating a formula that will pull through the amount of type A i have delivered month. Thanks in advance, Katie
-
Formula Help
Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market. for example all total of type A for Jazz (campaign) AT (market) I thought it would be something like, but neither are working =SUMIFS(Campaign:Campaign, "Jazz", Market:Market, "AT",…