1张表格- 2张表格
最佳答案
-
保罗新来的 ✭✭✭✭✭✭您将让表单为所有条目填充相同的工作表，然后设置Move Row自动操作，以便在添加一行并且该特定答案是您希望在另一个工作表上的答案时触发。
thinkspi.com
0
答案
类别
You can use Conditional Formatting to set a color based on the value in a cell, but not to randomize the colors unfortunately. It's a fixed color per formatting rule. You could use a contact field to use different colors for different people though...maybe have every project that George is managing be in dark blue, Wanda in orange, etc. Or some other value that you preset (big projects in red, small in green, etc) that has enough variation to help with the visuals.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-25 18:00:14","updateUser":{"userID":151609,"name":"longlive289s","url":"https:\/\/community.smartsheet.com\/profile\/longlive289s","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-25T21:17:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}]},{"discussionID":94645,"type":"question","name":"When will report card views be editable on dashboards and workapps","excerpt":"The sheet card view functionality works so beautifully on dashboards and workapps 😍 (image attached of sheet setting options on workapps). Will this be available soonish for card views on reports? Currently, the only editable report option is grid view on workapps. The workaround I'm implementing is to add the card view…","categoryID":321,"dateInserted":"2022-08-25T01:27:07+00:00","dateUpdated":null,"dateLastComment":"2022-08-25T13:29:01+00:00","insertUserID":122359,"insertUser":{"userID":122359,"name":"Amanda G Lima","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Amanda%20G%20Lima","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!aTlUGrCEcLw!XmjWXyseFaQ!SRWK24M5uLR","dateLastActive":"2022-08-25T14:28:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-08-25T13:34:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3322825568,"url":"https:\/\/community.smartsheet.com\/discussion\/94645\/when-will-report-card-views-be-editable-on-dashboards-and-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94645\/when-will-report-card-views-be-editable-on-dashboards-and-workapps","format":"Rich","tagIDs":[265,292,371,391,444],"lastPost":{"discussionID":94645,"commentID":341152,"name":"Re: When will report card views be editable on dashboards and workapps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/341152#Comment_341152","dateInserted":"2022-08-25T13:29:01+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-08-25T13:34:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-25T14:29:27+00:00","dateAnswered":"2022-08-25T13:29:01+00:00","acceptedAnswers":[{"commentID":341152,"body":"
Fell free to brows the Ideas Topic. If someone has already made the suggestion, you can vote for it. If no one has then you can submit the idea yourself to let Smartsheet know it is a requested feature and allow others to vote for it.<\/p>
<\/p>
