Formulas

SharonR

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???? Im thinking of a helper column... 

Paul Newcome

To use a date in a formula, use

 

DATE(yyyy, mm, dd)

 

To AVG Harvey Balls, you will need to designate a number to each status level. There are a few ways to accomplish this. You mentioned a helper column in your post. That's the easiest way to do it actually.

 

Use a nested IF statement to establish a number in place of the Harvey ball status then AVG your helper column.