-
Select separate values from multi-select cells
I have a sheet where staff input their hours available in a week. I have the formula to calculate the hours available for the week. However, staff can enter multiple start and end times, if they are available from 8:00am - 10:00am and then from 3:30pm to 5:00pm. The formula still works for the first set of numbers, but…
-
Report date a document was modified
I am trying to report via a summary sheet the date that the a sheet was updated. I am wanting to report when any row on the sheet was updated not just a specific line. I'm hoping that its something really simple that I've missed.
-
Using a formula in RYGG but it disappears when used manually
I have a Contract Health column in my sheet to note the health of a contract which would be a manual process to move from R, Y or G. However, if the contract is closed, I wanted it to check the "Expired" column and then to automatically revert to Grey. I copied the formula down but when I made the row Red to test I noticed…
-
Cross Sheet Fixed Cell References
Hello, Is it possible to create a fixed cross sheet reference such that my formulas will always pull the first row of data from the target sheet? I am building a Dashboard off of results from a Form that I have set to add new submissions at the top i.e. row 1. As new submissions get added, I want the Dashboard to update,…
-
Multiple Criteria, total count
Hi All, I am trying to do calculate a total number of events, that match criteria for 1. Date range (can also use fiscal column as a matching criteria where i only want those that contain specific letter/numerical value = Q2) for all -NDA Webinars. I don't want it to count each column that matches the criteria, but if the…
-
COUNFIFS and FIND formula for weekly schedule
Hi Community, hope you are well! Hope someone could help with the following formula syntax. I am building a weekly schedule for the creative studio. I would like to calculate how to count a specific entry such as "Email" across the schedule.I have columns for Week starting date, assigned, daily schedule broken down in half…
-
Help with writing a status formula
Hi, I am trying to use a Status column to show the status of these criteria: If [25-Hour Training] is blank and [5 Hour Training] is blank = red If [25-Hour Training] is blank and [5 Hour Training] is not blank = yellow If [25-Hour Training] is not blank and [5 Hour Training] is not blank = green using a separate metrics…
-
Combining two forms into one sheet for one report
Hi, I have two sheets that are being populated by forms that staff will be filling out. I have created a third tracking sheet with columns that I want to auto-populate using some of the fields from each form so that I can create one master sheet with condensed information and create a report to display on a dashboard (not…
-
Basic RAG Calculation formula based off completion % in project schedule
Hello All, I would like to know if anyone knows how to set up a basic RAG formula based on completion % and the schedule date. Custom criteria would be as follows: If % Complete = 100, return Blue If it's not scheduled to start yet, return Clear/Grey If past the scheduled finish date and % complete is less than 100%,…
-
Function for Calculating with Dropdown Boxes
Hello - We have a column that has a checkbox for each year, and another column with a numeric number in it (called Complexity Score (NUMERIC FIELD ONLY) on my screen print). If someone has January, March, April and Sept checked for months in the dropdown column, I need to calculate a the numeric number times how many…