One entry, multiple days in a month



I have a reasonable amount of experience with Smartsheet but am a bit stumped on how to approach my latest challenge. I would like to use Smartsheet to take in several data points for events over the course of a month. The challenge is the same event will take place over multiple days during the same month and I don't want to have a form completed for each date individually.

For example, if the event takes place on Feb 1st - 5th, but it is in different cities on each date, I would like to avoid completing 5 different forms to account for each instance of the event. Can anyone suggest a better way of data intake OR a way to use a form that I've not considered?

Thank you.

Best Answer