I am trying to determine a Classification when a Weighted Score is between two values.
=IF(AND([Weighted Score]15 > 31, [Weighted Score]15 < 61, "B"))
In this formula, I want to return a "B" when a Weighted Value is between 31 and 61. But I get Incorrect Argument. Can someone please help me.
I have formulas written based on a date but some of the dates in my sheet contains blanks or text. So in my formula, it is giving me an Invalid Data Type error. Is there a way to determine if the date is valid date in the formula? I can check for blank, but dont know how to check for anything
I want to count the number of items when their description contains a certain word.
Count if Description contains the word "grey". There would be multiple descriptions with the word GREY in the column. Ex. Dark Grey, Grey Mist, Green Grey, Blue Grey. I want a total for all items that are GREY.
I am trying to populate an Actual Start Date field with the current date when a checkbox is checked (Task Started). I am using the TODAY feature in my formula for my Actual Start Date. But what I am seeing that when I open my sheet it populates all of those dates with TODAY's date so I loose the