Is Dynamic View faster than a regular sheet
Hello,
I have run into the issue with a Smartsheet being slow due to the complexity of formulas I have created. I was wondering if anyone knew if using Dynamic view results in less lag than just filling in the sheets. Just wanted to double check before I spend the time building it in case it has no effect.
Thank you
Michael
Answers
-
Andrée Starå ✭✭✭✭✭✭Hi Michael,
My experience is that it’s faster, but I’ll try a little later and get back to you with the results!
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
工作流顾问/ CEO @WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community bymarking it 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 for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
You would need a helper column to change to current date then in the cell you want the actual date to be you would need to use the formula of =[helper column date]@row+7<\/p>
For the symbol you would need to do something similar as symbol automation is not currently an option that I am aware of but you can have a helper column change to specific criteria and then set up a formula in your symbol column to reference that cell with an if formula to get the symbol you would like to appear when the cell is changed to the specified criteria<\/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":88567,"type":"question","name":"WorkApps custom filters and export to MS Excel","excerpt":"Is there a way to allow users who have edit rights to a page in WorkApps to create custom filters and export the sheet to MS Excel? These features are available if you give someone edit permissions directly to the sheet but not when assigning permissions via WorkApps.","snippet":"Is there a way to allow users who have edit rights to a page in WorkApps to create custom filters and export the sheet to MS Excel? These features are available if you give…","categoryID":343,"dateInserted":"2022-03-02T20:39:36+00:00","dateUpdated":"2022-06-14T14:39:14+00:00","dateLastComment":"2023-11-01T16:03:21+00:00","insertUserID":61706,"insertUser":{"userID":61706,"name":"GilN","url":"https:\/\/community.smartsheet.com\/profile\/GilN","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m9FAn2LNZfo!-nlDNzbiEjw!ZXrmqK8UUTk","dateLastActive":"2023-03-27T19:45:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":169385,"lastUser":{"userID":169385,"name":"prh_intl","title":"Relocation Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/prh_intl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T16:09:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":533,"score":null,"hot":3345109977,"url":"https:\/\/community.smartsheet.com\/discussion\/88567\/workapps-custom-filters-and-export-to-ms-excel","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/88567\/workapps-custom-filters-and-export-to-ms-excel","format":"Rich","lastPost":{"discussionID":88567,"commentID":402570,"name":"Re: WorkApps custom filters and export to MS Excel","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402570#Comment_402570","dateInserted":"2023-11-01T16:03:21+00:00","insertUserID":169385,"insertUser":{"userID":169385,"name":"prh_intl","title":"Relocation Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/prh_intl","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-11-01T16:09:24+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-03-08T03:57:28+00:00","dateAnswered":"2022-03-05T18:47:42+00:00","acceptedAnswers":[{"commentID":321678,"body":"
Hi @GilN<\/a> <\/p> I hope you're well and safe!<\/p> Unfortunately, it's not possible now, but it's an excellent idea!<\/p> Please submit an Enhancement Request when you have a moment<\/strong><\/a>.<\/strong><\/p> I hope that helps!<\/p> Be safe and have a fantastic weekend!<\/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 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":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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&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":719,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
