I have two sheets: Sheet 1 that people use to submit requests for course redevelopments and Sheet 2 that has a record of all 1,000 courses (with a link to the "master" in our learning management syste…
Hello All, I am hoping someone can help me. I am trying to make an attendance sheet that will automatically deduct hours from the user's allotment based on manager approval and to also deduct from the…
I'm trying to write a formula using an IF/OR statement to set a flag (for the Revised Timeline column) when NA has been selected from a drop-down menu in the any one of five columns (e.g., Reason for …
I am looking for a formula that will help me achieve a percentage complete column that will reflect the number of subtasks complete divided by the number of subtasks. For example: Parent folder with 3…
I have a percentage in a cell that has been derived by subtracting one percentage from another. ie 5% - 10% = -5% and I now want to represent this answer as a R A G coloured blob symbol, where: < -4.9…
Hello, I am trying to see if there is a formula I could use in a hidden column, with a checkbox, where when a new form is submitted (and a new line is then entered onto a sheet) it would alert me if t…
Hi all - First Discussion here. I am trying to use a formula that will populate a cell with "Not Started", "In Progress" or "Completed" based on the condition of eight cells in the same row have data …
Hi I am struggling to get the total for all the columns in my sheet for each week Monday- Sunday. My entries are created via webform. I need to take into consideration the created date for my weekly t…
Looking for help on a formula! I want to sum the Forecast Amount values where the Sales Stage is equal to the value in the Status column. So for example, Status11 is equal to 2 - Qualification. I want…
Is there a formula or a work around to produce the duration of a project when given the start date of the project and the end date of a project? In Excel (=DATEDIF(D9, E9, "d") is a simple formula but…