Formula referencing cell in newly submitted row

Roland Horwood

Hi all,

 

I fear this may be impossible, but it's always worth asking.

I have a simple time logging sheet with a web form that just asks what project a user is working on. I have system columns use the time stamp from the web form to log the time.

 

I am trying to use the difference between the submitted time and the last submission to work out the time logged against that project. Unfortunately this means the formaula has to reference a yet to be submitted row! This works fine when referncing a blank lione, but as soon as a row is submiited and added to the bottom of the form, the formula gives a refencing error.

 

Is there any way round this?

 

Roland

Roland Horwood

Morning,

 

I'm not sure what I did, but the error has gone away. The previous row now happily references the most recently submitted row allowing the time elapsed to be calulated againt the appropriate entry.

 

Roland