Help with Formula!
I'm pretty new to smartsheet but slowly working out how to create some functioning formulas! I wonder if anybody might be able to help me with the latest one please?
I have multiple columns containing different data types (some are tick boxes, others are dates and some will say 'N/A' - I am trying to write a formula to return 'Package Complete' is all columns are not blank, or return 'Documents Pending' is any of them are blank...
Is this possible??
Help Article Resources
Check out the Formula Handbook template!