I have a simple form. There is a drop down that contains 2 values - New (default) and Assigned. I have a workflow that records when the value is changed to Assigned and a report that captures when a form is created and that timestamp.
My question is if a user creates the form and ALSO changes the value to Assigned the timestamp shows that the value was changed 1 second before the form was created. This is throwing off the report. Is there any way around this?
If there is no way around this, does anyone have an idea how I can modify the excel formula to not error out....
how exactly do you capture "the timestamp" for assigned state?
you could make a condition in the workflow - if "the timestamp" is less then created time then save created time, otherwise "the timestemp".
... or you could make a conditional formula in excel report