I am trying to figure out how to make a yes/no column named "completed" auto-fill "yes" when data has been entered and proofed. Column1 and Column2 in my sample formulas can either be a data enterer/proofer's name (text) or hours billed (number).
We can use either column for the formula but basically what I want to happen is when both the entered and the proofed columns are filled (name or hours), the "completed" cell will return "yes"(TRUE), or vise-versa (if either is blank it returns "no" (false), as seen in my sample formulas).
A few questions concerning this task:
- What is the syntax for a blank cell?
"EMPTY"? EMPTY? BLANK? Or must I use the ISBLANK function?
- What is the syntax for not equal to?
<>, like in excel? Does this work for both text and number cells in SharePoint?
- Which would be better for this formula, an OR statement identifying either cell is blank or an AND statement identifying both cells have a value (any value)?
Samples:
=IF(OR([Column1]=BLANK,[Column2]=BLANK),FALSE)
=IF(AND([Column1]<>BLANK,[Column2]<>BLANK),TRUE)