-
Trying to Clear a "Ball in Court" cell when item is complete
Help! We are trying to set up a formula to clear the "Ball In Court" when a line is complete. I know that you cannot format a formula in a contact cell, but there has to be a way! It's appearing as though work is still needing done and it is not plausible to remember to clear the cell each time something is complete. Any…
-
Automating R/Y/G/G Formula for some colors
Hello - Is it possible to create a formula that only looks for some of the colors in the R/Y/G/G drop down column. My drop down order in the Stage column is Not Started, In Progress, Completed. In my Status column I have Red, Yellow, Green, Gray. I am looking to create a formula that enters a 'Gray' icon when 'Completed'…
-
How to start counting the number of days up from a [Start Date] column, but ending it when the job i
Are you able to provide a formula that will for for the following: to start counting the number of work days up from a [Start Date] column, but ending it when the job is completed (whether is be an action or another date is reached)? Much thanks
-
Need Formula to count if cell values are Greater than 0.5
I have tried several different formulas to determine how many cells have a value greater than 0.5. The cells are qtr 1, qtr2, qtr3, qtr4, qtr5, qtr6, qtr7, and qtr8. The cells are not next to each other so it can not be a range. Any suggesstions? Forrest
-
Percentage of Total Tasked Complete
Good afternoon everyone! I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column…
-
Formula for addition of quantities
Good afternoon, I am attempting to create a formula that adds the sum of multiple quantities. How would I create this formula and assign values to different types of information within this formula?
-
Unparesable Error
Receiving unparseable error when selecting a field in one column and wanting a specific result in another field. This is the formula. What am I missing? =IF([Submit for Approval]1,1[Manager Approval]1 = "Submitted") See attached
-
Formulas
Hello, I am needing help with this formula =IF({Colunm Range 1} >= 10, "Met", "To be Started") (this works but will not be relevant for the whole year.) How can I add in a date? I was this formula to recognise if a range is equal to or great than 10 after the 01/03/19, "Met', "Risk" Also can you AVG Harvey balls at all????…
-
Reference a Report
I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked. Ideally, I would like for the Task Name to populate according to those available based on the Project selected. For example, if the user…
-
Symbol Formula
Good morning, I am inquiring about a formula that adds a quantity of certain symbols within a sheet. I would like the total of check marks to be added. Attached is a screenshot of what I have unsuccessfully attempted thus far. Please let me know what changes are needed. Thank you