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.
Creating multiple row entries from one submitted web form?
Back with (what I believe to be) another obscure question that I don't know how to search for nor find an answer to. I'm attempting to work around the issue of not being able to have more than two dates in a row - we run news stories to multiple audiences so would prefer to have one row for each story, with up to ~10 date columns to tell us when it hits specific audiences. Since this is not possible, I'm hoping to find another solution that would prevent me from having to create 10 different rows for each date a news story is going out. Is there a formula that could help me split out/duplicate a web form entry? I currently have the form set up with 10 date fields, each corresponding to the audience type. In a perfect world I'd like a way to duplicate the entry X amount of times depending on the selected dates. IE: submitted form "News story 1" is going to Audience A 01/02/17, Audience B 01/03/17, Audience C 01/04/17. The submitted form gets duplicated three times into three seperate rows...one with a start date of 01/02/17, one with a start date of 01/03/17, and the last with a start date of 01/04/17. Is this something Smartsheet could do? Happy to read other suggestions, but unfortunately the brilliant suggestions I've already received to work around the two dates-only rule won't find our business needs. Thanks in advance!