Formula for highest value in rows to right

1

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.
image

2

Hey @Percy_Smallridge,

You should be able to set up a table with the following columns.

Name of project
Latest Revision
Date created
Date Modified
Version Number

From there you can have people make edits and adjustments and the modifiedby() and modified() formulas will pull who last edited and when it was modified.

Hope that helps!

Best,
Dan