Hello, I have a status column and a %compelete column in my workbook. I would like my %complete column to autopopulate 100%, when the status clumn is changed to "complete"
I am writing the If statement, however the column does not reflect a code, it is listed as text
Help Article Resources
Check out the Formula Handbook template!