Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula referencing cell in newly submitted row

Roland Horwood
Roland Horwood ✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

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

Comments

  • Roland Horwood
    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

This discussion has been closed.