For example, the cell reads "Smith, Johnny" and I want to write a formulat that returns a result if the cell contains "John". Normally I would use =if(cell,"*John*","YES","NO") with the wildcard * bef…
Here's the situation: I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estima…
Hi! I have two columns. One if the Due Date and the other is the Completed Date. I would like to set-up an equation where it counts the number of times an item was completed late (after the due date).…
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 th…
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 …
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 ac…
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 oth…
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 m…
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?
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…
