Trying to create a submission register with a row that shows the latest revision, to be compatible with letters or numbers. Can someone help me on the formula required to achieve this?
I have created this in excel already and trying to replicate into Coda. In excel i have used the following formula: =LOOKUP(2,1/(H12:T12<>“”),H12:T12)
See image below of how this currently looks, and what i am trying to replicate into coda.