Sign in to submit new ideas and vote
Get Started

Random Number Function

KeithBCP
KeithBCP ✭
edited 07/20/23 inSmartsheet Product Feedback & Ideas

Add a random number function, its 2023 and this functionality is basic in spreadsheets and has been around for 30 years. It is really incredible Smartsheets doesnt have this functionality.

Share on Facebook Share on Twitter
2
Up
2 votes

Idea Submitted·Last Updated

Comments

Categories

2023-06-28T00:46:24.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":108187,"type":"idea","name":"Cell-level Comments","excerpt":"Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads \"Cell\" next to the \"Row,\" \"Sheet,\" and \"All\" tabs. Currently, I'm spending a lot of time describing columns and going back and forth on communication to confirm columns and which…","snippet":"Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads \"Cell\" next to the \"Row,\" \"Sheet,\" and…","categoryID":349,"dateInserted":"2023-07-27T15:06:03+00:00","dateUpdated":"2023-07-27T15:07:29+00:00","dateLastComment":"2023-07-27T15:06:03+00:00","insertUserID":149231,"insertUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":149231,"lastUserID":149231,"lastUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":16,"score":5,"hot":3380942312,"url":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","format":"Rich","tagIDs":[319,363,391,441,507,566],"lastPost":{"discussionID":108187,"name":"Cell-level Comments","url":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","dateInserted":"2023-07-27T15:06:03+00:00","insertUserID":149231,"insertUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":5}],"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":566,"urlcode":"idea","name":"idea"}]},{"discussionID":108153,"type":"idea","name":"Controlled data: Create Rows but not Edit OR Edit Rows but not Create","excerpt":"prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit but stop them from creating new ones.","snippet":"prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit…","categoryID":349,"dateInserted":"2023-07-26T23:06:59+00:00","dateUpdated":"2023-07-27T11:50:10+00:00","dateLastComment":"2023-07-27T11:53:06+00:00","insertUserID":81486,"insertUser":{"userID":81486,"name":"Trish Dillon","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Trish%20Dillon","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ejFZp_HtGHw!wf9YcMXtCfo!EieK1GzsuNz","dateLastActive":"2023-07-27T17:04:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":1,"hot":3380872505,"url":"https:\/\/community.smartsheet.com\/discussion\/108153\/controlled-data-create-rows-but-not-edit-or-edit-rows-but-not-create","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108153\/controlled-data-create-rows-but-not-edit-or-edit-rows-but-not-create","format":"Rich","tagIDs":[219,363],"lastPost":{"discussionID":108153,"commentID":387483,"name":"Re: Controlled data: Create Rows but not Edit OR Edit Rows but not Create","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387483#Comment_387483","dateInserted":"2023-07-27T11:53:06+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":108141,"type":"idea","name":"Automatically Update Numbers in Countdown Formula","excerpt":"Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.","snippet":"Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools…","categoryID":349,"dateInserted":"2023-07-26T20:05:36+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T11:38:35+00:00","insertUserID":164136,"insertUser":{"userID":164136,"name":"mp_12","url":"https:\/\/community.smartsheet.com\/profile\/mp_12","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-26T20:02:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":23,"score":3,"hot":3380861351,"url":"https:\/\/community.smartsheet.com\/discussion\/108141\/automatically-update-numbers-in-countdown-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108141\/automatically-update-numbers-in-countdown-formula","format":"Rich","tagIDs":[219,319,334,363,391,440],"lastPost":{"discussionID":108141,"commentID":387478,"name":"Re: Automatically Update Numbers in Countdown Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387478#Comment_387478","dateInserted":"2023-07-27T11:38:35+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-06-28T00%3A46%3A24%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":170,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">