Is it possible to create a form with the fields next to each other instead of below

Rachel Conde-Wixted
Rachel Conde-Wixted ✭
inFormulas and Functions

I'm working on creating a form but we would prefer that the fields be next to each other for comparisons instead of below. I was wondering if anyone know is this is a possibility, the forms see very linear not a lot of wiggle room.

· Share on Facebook Share on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the公式手册模板!

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video
Hi @l.gann<\/a> <\/p>

I hope you're well and safe!<\/p>

You could add a so-called helper column and reference a specific cell for check all and have a workflow trigger from it, and that would check all the boxes.<\/p>

Make sense?<\/p>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":108075,"type":"question","name":"Join Formula with Dates - How to eliminate the time stamp?","excerpt":"I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##\/##\/## 8:00 AM - ##\/##\/## 4:59 PM\" and I…","snippet":"I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted…","categoryID":322,"dateInserted":"2023-07-25T23:25:07+00:00","dateUpdated":null,"dateLastComment":"2023-07-26T16:37:18+00:00","insertUserID":151681,"insertUser":{"userID":151681,"name":"Carly Chaput","url":"https:\/\/community.smartsheet.com\/profile\/Carly%20Chaput","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7LDR-2jLTOc!ncHRPxz3FX0!r2XVfx-Tpm0","dateLastActive":"2023-07-26T16:36:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":151681,"lastUser":{"userID":151681,"name":"Carly Chaput","url":"https:\/\/community.smartsheet.com\/profile\/Carly%20Chaput","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7LDR-2jLTOc!ncHRPxz3FX0!r2XVfx-Tpm0","dateLastActive":"2023-07-26T16:36:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3380718745,"url":"https:\/\/community.smartsheet.com\/discussion\/108075\/join-formula-with-dates-how-to-eliminate-the-time-stamp","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108075\/join-formula-with-dates-how-to-eliminate-the-time-stamp","format":"Rich","tagIDs":[219,254,391,437,440],"lastPost":{"discussionID":108075,"commentID":387232,"name":"Re: Join Formula with Dates - How to eliminate the time stamp?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387232#Comment_387232","dateInserted":"2023-07-26T16:37:18+00:00","insertUserID":151681,"insertUser":{"userID":151681,"name":"Carly Chaput","url":"https:\/\/community.smartsheet.com\/profile\/Carly%20Chaput","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7LDR-2jLTOc!ncHRPxz3FX0!r2XVfx-Tpm0","dateLastActive":"2023-07-26T16:36:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JUP9P0NLORVI\/example-join-formula-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"example join formula.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-26T16:37:00+00:00","dateAnswered":"2023-07-26T00:23:18+00:00","acceptedAnswers":[{"commentID":387066,"body":"

Hi Carly, <\/p>

You could use the following formula to join without populating a timestamp: <\/p>

=[Task Name]@row + \" - \" + [Start Date]@row + \" - \" + [End Date]@row<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"},{"commentID":387099,"body":"

Hi @Carly Chaput<\/a> <\/p>

I hope you're well and safe!<\/p>

Because you're using the Dependencies feature, you must use something like the one below.<\/p>

=[Task Name]@row + \" - \" + DATEONLY([Start Date]@row) + \" - \" + DATEONLY([End Date]@row)\n<\/pre>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic week!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}]},{"discussionID":108057,"type":"question","name":"How to return multi-select values using INDEX\/COLLECT","excerpt":"Need the Smartsheet fam expert knowledge. I am trying to return a value (persons name) based on the hospital dept they work in. I created a reference guide crosswalk with name in one column and the name of the dept in another. There are multiple names that work in the same dept FYI. I import hospital data and am trying to…","snippet":"Need the Smartsheet fam expert knowledge. I am trying to return a value (persons name) based on the hospital dept they work in. I created a reference guide crosswalk with name in…","categoryID":322,"dateInserted":"2023-07-25T19:15:45+00:00","dateUpdated":null,"dateLastComment":"2023-07-26T18:41:09+00:00","insertUserID":140506,"insertUser":{"userID":140506,"name":"Elguapo24","url":"https:\/\/community.smartsheet.com\/profile\/Elguapo24","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pbFUaTHZtPw!m9_WH_25ZP4!gzRzebFei0D","dateLastActive":"2023-07-26T18:42:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":140506,"lastUser":{"userID":140506,"name":"Elguapo24","url":"https:\/\/community.smartsheet.com\/profile\/Elguapo24","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pbFUaTHZtPw!m9_WH_25ZP4!gzRzebFei0D","dateLastActive":"2023-07-26T18:42:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3380710614,"url":"https:\/\/community.smartsheet.com\/discussion\/108057\/how-to-return-multi-select-values-using-index-collect","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108057\/how-to-return-multi-select-values-using-index-collect","format":"Rich","lastPost":{"discussionID":108057,"commentID":387333,"name":"Re: How to return multi-select values using INDEX\/COLLECT","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387333#Comment_387333","dateInserted":"2023-07-26T18:41:09+00:00","insertUserID":140506,"insertUser":{"userID":140506,"name":"Elguapo24","url":"https:\/\/community.smartsheet.com\/profile\/Elguapo24","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pbFUaTHZtPw!m9_WH_25ZP4!gzRzebFei0D","dateLastActive":"2023-07-26T18:42:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-26T18:40:25+00:00","dateAnswered":"2023-07-26T18:18:41+00:00","acceptedAnswers":[{"commentID":387307,"body":"
You are actually going to need a JOIN\/COLLECT to bring together multiple cells from the reference sheet to the working sheet.<\/p>
=JOIN(COLLECT({educator range}, {department}, [Combine:BU\/Dept]@row), \"delimiter of choice\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
           

             

              
Trending in Formulas and Functions

             

             
    
              
  • Auto check all check boxes in a column
    Hello! I have a sheet with a check box column where end users select the check box to nominate a speaker which will trigger a separate workflow. The issue with individually selecting is that there can be upwards of 100 speakers on the list. Is there a way to have an option for the end user to click one check box or choose…
    • 
              
  • Join Formula with Dates - How to eliminate the time stamp?
    I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
    • 
              
  • How to return multi-select values using INDEX/COLLECT
    Need the Smartsheet fam expert knowledge. I am trying to return a value (persons name) based on the hospital dept they work in. I created a reference guide crosswalk with name in one column and the name of the dept in another. There are multiple names that work in the same dept FYI. I import hospital data and am trying to…
    •