Forms URL query String, IS there a limit to how many queries can be used?

Hi, I am a novice with Smartsheet, but am learning.

I have a form that I need to pre-populate so we can send it out to technicians to complete a field report.

I can get five fields to populate, but no more than that.

="https://app.smartsheet.com/b/form/d2cda8ab647e4c11b40e503977eb916b?Part%20Number="+ [Part Number]@row + "&Serial%20Number=" + [Serial Number]@row + "&Customer%20Name=" + SUBSTITUTE([Customer Name]@row, " ", "%20") + "&Model%20Number=" + SUBSTITUTE([Model Number]@row, " ", "%20" + "&Install%20Date=" + [Install Date]@row + "&Notes%3A=" + SUBSTITUTE([Notes:]@row, " ", "%20") + "&Test%20One=" + SUBSTITUTE([Test One]@row, " ", "%20") + "&Test%20two=" + SUBSTITUTE([Test two]@row, " ", "%20"))

image.png

Any ideas?


Thank you,


Clint

Tags:

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    @cjg

    Excellent!

    You're more than welcome!

    Here's an excellent helpful article detailing the special characters that might need to be used to make the form work.

    Remember!Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

«1

Answers

  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭

    @cjg, honestly I think you just taught me something new—I didn’t know you could pre-populate data in a form so I’m going to play with this tomorrow. I guess my question is this: if you can pre-populate the form, is it possible to have a formula column on your target sheet that would populate the data once your initial entry is completed?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi@cjg

    I hope you're well and safe!

    There's no limit that I know of, and I've developed client solutions using a lot more fields than five, so there has to be an issue in the formula somewhere.

    I'll take a look and see if I can see it at a quick glance.

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @cjg

    Try something like this.

    ="https://app.smartsheet.com/b/form/d2cda8ab647e4c11b40e503977eb916b?Part%20Number="+ [Part Number]@row + "&Serial%20Number=" + [Serial Number]@row + "&Customer%20Name=" + SUBSTITUTE([Customer Name]@row, " ", "%20") + "&Model%20Number=" + SUBSTITUTE([Model Number]@row, " ", "%20") + "&Install%20Date=" + [Install Date]@row + "&Notes%3A=" + SUBSTITUTE([Notes:]@row, " ", "%20") + "&Test%20One=" + SUBSTITUTE([Test One]@row, " ", "%20") + "&Test%20two=" + SUBSTITUTE([Test Two]@row, " ", "%20")

    Did it work?

    Remember!Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi Andree,

    No, that didn't work either. Same result as before.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @cjg

    Hmm. It works for me.

    Can you share some screenshots of the column names in the sheet?(Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hey Lucas,

    Yes, this form is connected to another sheet. Once our customer fills out the service request, I set up an automation to another sheet we are trying to auto-populate. This form will go to our technician. The tech will fill out the fields that pertain to them and once they submitted it will be on my sheet. That is the hope, if I can get it to work,

  • Hi Andree,

    The second URL was me testing it again this morning. I have had some issues that if the field was not on the original URL it would not display.

    image.png


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @cjg

    I see the issue.

    I'll get back to you!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @cjg

    Try this one.

    ="https://app.smartsheet.com/b/form/d2cda8ab647e4c11b40e503977eb916b?Part%20Number="+替代(替代(替代(替代([标准t Number]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Serial%20Number=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Serial Number]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Customer%20Name=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Customer Name]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Model%20Number=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Model Number]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Install%20Date=" + [Install Date]@row + "&Notes%3A=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Notes:]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Test%20One=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Test One]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Test%20two=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Test Two]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23")

    Did it work?

    Remember!Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • That worked. Obviously, what you wrote up is much more in-depth than what I had. Where can I look to learn what you did?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    @cjg

    Excellent!

    You're more than welcome!

    Here's an excellent helpful article detailing the special characters that might need to be used to make the form work.

    Remember!Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @cjg

    I don't know what happened, but I noticed the link wasn't included. Here it is again.


    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Here is my suggestion for helping to keep these URL formulas a little bit tidy (or at least as tidy as they can be).


    Think of it in three sections. You have one section that contains the fields and data to populate, you have a second section that will be swapping out your characters for the correct % encoding, and another section that is the "base" of the url.


    I work my formulas in that order.

    = "字段名称1 = " +(字段名1)@row +"Field Name 2=" + [Field Name 2]@row


    The above generates the string that will take care of the fields and their data. Now I start wrapping the whole thing in my SUBSTITUTE functions to take care of the % encoding.

    =SUBSTITUTE(SUBSTITUTE("Field Name 1=" + [Field Name 1]@row + "&Field Name 2=" + [Field Name 2]@row, " ", "%20"), "/", "%2F")


    Then I will add my base URL at the beginning.

    ="URL?" +SUBSTITUTE(SUBSTITUTE("Field Name 1=" + [Field Name 1]@row + "Field Name 2=" + [Field Name 2]@row, " ", "%20"), "/", "%2F")


    .


    Doing it this way allows me to focus on each of the main pieces on at a time and also helps keep me from having to repeat the same SUBSTITUTE functions multiple times through the string which helps cut down on all those parenthesis and syntax issues as well as troubleshooting finding specific fields and whatnot. It also makes it easier to adjust for different characters that need swapped out because I can just add a SUBSTITTUE to the beginning (after the base URL) and then take care of the character swap at the end. And you don't have to try to remember to always type "%20" everywhere there is a space in a field name or anything like that.


    .


    That turns this:

    ="https://app.smartsheet.com/b/form/d2cda8ab647e4c11b40e503977eb916b?Part%20Number="+替代(替代(替代(替代([标准t Number]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Serial%20Number=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Serial Number]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Customer%20Name=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Customer Name]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Model%20Number=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Model Number]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Install%20Date=" + [Install Date]@row + "&Notes%3A=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Notes:]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Test%20One=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Test One]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23") + "&Test%20two=" + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Test Two]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23")


    Into this:

    ="https://app.smartsheet.com/b/form/d2cda8ab647e4c11b40e503977eb916b?"+ SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("Part Number=" + [Part Number]@row + "&Serial Number=" + [Serial Number]@row + "&Customer Name=" + [Customer Name]@row + "&Model Number=" + [Model Number]@row + "&Install Date=" + [Install Date]@row + "&Notes:=" + [Notes:]@row + "&Test One=" + [Test One]@row + "&Test Two=" + [Test Two]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23")

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    It keeps freezing when I try to edit my post above. I had a small typo.

    "&TestTwo="

    should be

    "&Testtwo="


    ="https://app.smartsheet.com/b/form/d2cda8ab647e4c11b40e503977eb916b?"+ SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("Part Number=" + [Part Number]@row + "&Serial Number=" + [Serial Number]@row + "&Customer Name=" + [Customer Name]@row + "&Model Number=" + [Model Number]@row + "&Install Date=" + [Install Date]@row + "&Notes:=" + [Notes:]@row + "&Test One=" + [Test One]@row + "&Testtwo=" + [Test Two]@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23")

How exactly is your Data Shuttle set up? If it is set to replace everything in the sheet when it runs, it is deleting the cell being referenced by the widget and then putting new data in new cells.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":108213,"type":"question","name":"How to spread costs evenly across months, if they fall within those dates","excerpt":"I have various financial line items that span different dates. I'd like the costs to be spread per month automatically based on the date and cost entry. I've tried various functions already, IF, AND, and it says Unpearsable. I'd like to spread out the costs in the Cost column to the months on the right, based on the start…","snippet":"I have various financial line items that span different dates. I'd like the costs to be spread per month automatically based on the date and cost entry. I've tried various…","categoryID":321,"dateInserted":"2023-07-27T19:03:42+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T21:12:20+00:00","insertUserID":164209,"insertUser":{"userID":164209,"name":"AshwiniBiotech2023","title":"Sr. Director, Project Management","url":"https:\/\/community.smartsheet.com\/profile\/AshwiniBiotech2023","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T23:10:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164209,"lastUser":{"userID":164209,"name":"AshwiniBiotech2023","title":"Sr. Director, Project Management","url":"https:\/\/community.smartsheet.com\/profile\/AshwiniBiotech2023","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T23:10:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":67,"score":null,"hot":3381071762,"url":"https:\/\/community.smartsheet.com\/discussion\/108213\/how-to-spread-costs-evenly-across-months-if-they-fall-within-those-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108213\/how-to-spread-costs-evenly-across-months-if-they-fall-within-those-dates","format":"Rich","lastPost":{"discussionID":108213,"commentID":387925,"name":"Re: How to spread costs evenly across months, if they fall within those dates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387925#Comment_387925","dateInserted":"2023-07-28T21:12:20+00:00","insertUserID":164209,"insertUser":{"userID":164209,"name":"AshwiniBiotech2023","title":"Sr. Director, Project Management","url":"https:\/\/community.smartsheet.com\/profile\/AshwiniBiotech2023","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T23:10:16+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/IBAVVE3YLO8D\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T09:38:32+00:00","dateAnswered":"2023-07-27T19:21:12+00:00","acceptedAnswers":[{"commentID":387646,"body":"

You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>

=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"

Lets try a different approach.<\/p>

=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/107057/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/107057/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p>


<\/p>

Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"

@AshwiniBiotech2023<\/a> Check out my last comment.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[]},{"discussionID":108239,"type":"question","name":"Is an automated export of a Smartsheet to an Excel file possible?","excerpt":"Hi all, I have been having the most frustrating conversation with Smartsheet support on this topic and not getting answers to the question that I asked. I would like to set up an automation that will email me an Excel copy of my project plans on a weekly basis (or when triggered with a change - I don't really care) as I…","snippet":"Hi all, I have been having the most frustrating conversation with Smartsheet support on this topic and not getting answers to the question that I asked. I would like to set up an…","categoryID":321,"dateInserted":"2023-07-28T02:36:12+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T06:42:13+00:00","insertUserID":164243,"insertUser":{"userID":164243,"name":"Candace G","title":"Senior Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Candace%20G","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T06:50:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137040,"lastUser":{"userID":137040,"name":"Gia Thinh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gia%20Thinh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pXMt6Y5Kqjs!ZHDtmZp0Yms!Dwma-t47hzh","dateLastActive":"2023-07-29T14:44:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":45,"score":null,"hot":3381040105,"url":"https:\/\/community.smartsheet.com\/discussion\/108239\/is-an-automated-export-of-a-smartsheet-to-an-excel-file-possible","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108239\/is-an-automated-export-of-a-smartsheet-to-an-excel-file-possible","format":"Rich","tagIDs":[268,334,440,445,510],"lastPost":{"discussionID":108239,"commentID":387741,"name":"Re: Is an automated export of a Smartsheet to an Excel file possible?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387741#Comment_387741","dateInserted":"2023-07-28T06:42:13+00:00","insertUserID":137040,"insertUser":{"userID":137040,"name":"Gia Thinh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gia%20Thinh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pXMt6Y5Kqjs!ZHDtmZp0Yms!Dwma-t47hzh","dateLastActive":"2023-07-29T14:44:33+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T06:32:42+00:00","dateAnswered":"2023-07-28T05:49:42+00:00","acceptedAnswers":[{"commentID":387737,"body":"

Hi Candace,<\/p>

The answer is YES. You can use \"Send as Attachment\" feature in the File menu of your sheet to setup the schedule for your need. You should be a licensed user to use this feature as well (I remembered that). <\/p>

Hope this works for you.<\/p>

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


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&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":4892,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics