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, pleaseVisit the Current Forums.

Enhancement Request: Auto-Refresh Functionality

jcamer25
jcamer25 ✭
edited 12/09/19 inArchived 2017 Posts

I would like to request the addition of an auto-refresh feature within Smartsheet. I use one worksheet most of the day and I have to manually refresh the worklist several times each hour. It would be great if the auto-refresh feature could trigger anytime someone performed a change but I would settle for an auto-refresh interval of every 5, 10, or 15 minutes.

Tags:
· Share on Facebook Share on Twitter

Comments

This discussion has been closed.

Categories

Hi @Neil Watson<\/a> <\/p>

Great idea! Yes, this is definitely possible, and I would do it exactly as you said. <\/p>

\"List Columns\"<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>


<\/p>

Then you can use the Array from the List Columns output as the Number of Runs in your Child Workflow Module:<\/p>


<\/p>


<\/p>


<\/p>

<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

In your Child Workflow, all you would need to do is include the {{runtime.data.column_id}} as both the Column ID and the Column Description in an Update Column module.<\/p>


<\/p>


<\/p>


<\/p>


<\/p>

I've hard-coded the sheet ID in there but you can make that dynamic as well depending on how you're passing that through the Parent workflow. <\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":107335,"type":"question","name":"SUMIFS - Stumped on calculation to figure out if within a month","excerpt":"Hi All, I am using SUMIFS to calculate if a part is in the Spend Formulas Range sheet and then if that same part has a Date that is within the month of January. The formula seems to break when the dates come in. =SUMIFS({2023 Spend Formulas Range 1}, {2023 Spend Formulas Range 2}, [Original Material #]@row,…","snippet":"Hi All, I am using SUMIFS to calculate if a part is in the Spend Formulas Range sheet and then if that same part has a Date that is within the month of January. The formula seems…","categoryID":322,"dateInserted":"2023-07-07T12:42:16+00:00","dateUpdated":null,"dateLastComment":"2023-07-07T18:51:25+00:00","insertUserID":151347,"insertUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-07T19:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":151347,"lastUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-07T19:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":71,"score":null,"hot":3377493221,"url":"https:\/\/community.smartsheet.com\/discussion\/107335\/sumifs-stumped-on-calculation-to-figure-out-if-within-a-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107335\/sumifs-stumped-on-calculation-to-figure-out-if-within-a-month","format":"Rich","lastPost":{"discussionID":107335,"commentID":384224,"name":"Re: SUMIFS - Stumped on calculation to figure out if within a month","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384224#Comment_384224","dateInserted":"2023-07-07T18:51:25+00:00","insertUserID":151347,"insertUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-07T19:28:35+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-07T18:12:06+00:00","dateAnswered":"2023-07-07T13:19:00+00:00","acceptedAnswers":[{"commentID":384153,"body":"

You need something more like this:<\/p>

=SUMIFS({2023 Spend Formulas Range 1}, {2023 Spend Formulas Range 2}, [Original Material #]@row, {Date Range}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023)<\/strong>)<\/p>


<\/p>

Then yes. You can drop them all inside of a SUM function or you can add them all together.<\/p>

=SUM(SUMIFS(.....), SUMIFS(.....), SUMIFS(.....))<\/p>

or<\/p>

=SUMIFS(.....) + SUMIFS(.....) + SUMIFS(.....)<\/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":[]},{"discussionID":107333,"type":"question","name":"Previous Month formula","excerpt":"Hi I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm struggling with is previous MTD. If the Create Date is the previous month, then check a box. If the Create Date is older than previous month,…","snippet":"Hi I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm…","categoryID":322,"dateInserted":"2023-07-07T12:17:35+00:00","dateUpdated":null,"dateLastComment":"2023-07-07T13:34:08+00:00","insertUserID":127983,"insertUser":{"userID":127983,"name":"Carol-Anne Cerbone","url":"https:\/\/community.smartsheet.com\/profile\/Carol-Anne%20Cerbone","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!h1jY4Qxc4TY!prNYaQRZvvo!a6wiwaB2GsY","dateLastActive":"2023-07-07T13:35:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T16:06:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":36,"score":null,"hot":3377470903,"url":"https:\/\/community.smartsheet.com\/discussion\/107333\/previous-month-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107333\/previous-month-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107333,"commentID":384162,"name":"Re: Previous Month formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384162#Comment_384162","dateInserted":"2023-07-07T13:34:08+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T16:06:46+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-07T13:23:44+00:00","dateAnswered":"2023-07-07T13:06:50+00:00","acceptedAnswers":[{"commentID":384144,"body":"

Hi @Carol-Anne Cerbone<\/a>,<\/p>

If you're just wanting the month to compare to last (e.g. July today vs. June last), then this will do what you're after:<\/p>

=IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = (MONTH(TODAY())) - 1), 1)<\/p>

Hope this helps! 😊<\/span><\/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":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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 Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Bridge to update column ID in column description

    Hi @Genevieve P. I am looking to develop a "utility" workflow that I can use when developing solutions. My idea is to use the "List Columns" element to gather the column ID's, and then a child workflow and "Update Columns" to update cycle through {{states.listcolumns.smartsheet.list_columns.data.x.column_id}} where x is…

  • SUMIFS - Stumped on calculation to figure out if within a month

    Hi All, I am using SUMIFS to calculate if a part is in the Spend Formulas Range sheet and then if that same part has a Date that is within the month of January. The formula seems to break when the dates come in. =SUMIFS({2023 Spend Formulas Range 1}, {2023 Spend Formulas Range 2}, [Original Material #]@row,…

  • Previous Month formula

    Hi I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm struggling with is previous MTD. If the Create Date is the previous month, then check a box. If the Create Date is older than previous month,…