What is a formula to look at series of columns, and check the box for the rightmost checked column
For example, I have a series of columns as follows, that go from left to right from beginning of process to the end of the process:
End of Feature Development
End of New Sale
End of Renewal
End of Support
End of Life
They are all checkbox columns. I would like a formula to look at all of the columns, and fill in the field with the rightmost column name. ie, if a row is checked up to "End of Renewal," I would like the field to fill with the text End of Renewal. If no columns are checked, I would like it to default to "Active"
Help Article Resources
Check out the Formula Handbook template!