formula

Sue van Niekerk

How do I do A formula that will

If Date Poles Completed is a date then Completion Column will Read "Completed" and if Date of Poles Completed is blank then A will also be blank

Sue van Niekerk

Also if

Completion is "Completed" then Invoice Status becomes "To Be invoiced"

Paul Newcome

You only need a basic IF statement for this.

=IF([Date Poles Completed]@row <> "", "Completed")