Can I submit multiple dates in a form for one event?

gburghes

I am trying to build a social media content calendar. We have our posting schedule laid out at regular intervals prior to the event. For example, if an event takes place on March 17th then we would have a post going out on March 10th, a reminder going our the 16th, and another post the day of the event. I am using Smartsheet forms to build and populate this calendar. Is there a way I can do one form submission that contains multiple dates and multiple titles so the form can populate the posting schedule all at once?

Currently, I am submitting a form for each row. So in my example above I would need to do 3 individual form submissions to complete the calendar. Is there a way I can build a form to do just one form submission to populate multiple actions on the calendar?

Gia Thinh

Hi gburghes,

Try this way.

First we use a "Event date input" with multi values. This field will be used in the Form for user's selection.

Then we use another column "Event date" with Date property

and get the date from "Event date input" by below formula

=DATE(VALUE(MID([Event date input]@row; 7; 4)); VALUE(MID([Event date input]@row; 4; 2)); VALUE(LEFT([Event date input]@row; 2)))

You can use "Date event" for caculating other dates of first, second and third posting.

Hope that help.

gburghes

Hello Gia Thinh,

Thank you for your help. When I enter the columns as you describe and the formula I continue to get a value of #UNPARSABLE. What are the number values referring to in the formula? 7;4 4;2 2?

bedholm

Did you ever figure this out? I am having the same issue and would love to know how you did it!

Gia Thinh

Hi,

=DATE(VALUE(MID([Event date input]@row; 7; 4)); VALUE(MID([Event date input]@row; 4; 2)); VALUE(LEFT([Event date input]@row; 2)))

In above formula, replace ";" with ","

I am in Vietnam so formula syntax may be different with your region.

bedholm

Thank you for responding Gia - I am still struggling to make this work. Any idea where I've gone wrong?

bedholm

Forgot to mention - I am getting "UNPARSEABLE" when I use the formula above

bedholm

I corrected the ; above and am now getting INVALID VALUE

Gia Thinh

Hi bedholm,

Due to your date format is mm/dd/yyyy (instead of dd/mm/yyyy as in Vietnam) then we should modify the formula as below:

=DATE(VALUE(MID([Event date input]@row, 7, 4)), VALUE(LEFT([Event date input]@row, 2)),VALUE(MID([Event date input]@row, 4, 2)))

Hope it works for you!

bedholm

Thank you correcting the date format worked! Appreciate your help :)

Gia Thinh

You're welcome!