I am trying to build an expense report sheet for external attendees that come to trainings. Is there a way to allow them to submit each expenses separately through a form but then somehow automatically group rows together so that we are only paying each person one time for multiple expenses? These people will only attend once, so individual sheets for each person are not a viable option.
The only thing I can think of would be to have one field that ties them all together and then create a total based on that amount using cross sheet formulas.
Does anyone have any other ideas or sheets set up that they use for a similar purpose?