I am trying to figure out how to make a column named "complete" 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 or the number of hours they billed.
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 blank? <>, 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)