Return a % if date in column
I am trying to create a formula where it identifies if there is a date in the Actual Start Column it is 50%, if there is a date in the Actual Start and Finish column it is 100% and no dates is 0%.
I managed to get it to work in excel using IFS but Smartsheet doesnt use IFS.
I tried using IF and OR but still no luck. Have now just tried IF(CONTAINS), I either get INPARESABLE or INCORRECT ARGUMENT.
It is taking to long to figure out myself. Could someone please help?
Help Article Resources
Check out the Formula Handbook template!