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