捕获不同列中的数据
答案
-
保罗新来的 ✭✭✭✭✭✭您需要包含尽可能多的单独列，以便允许在工作表本身中进行选择，以及要求用户输入总数的列。然后将所有这些字段添加到表单中，并设置表单逻辑，以便如果用户输入1，则只显示1个工作中心字段，如果用户输入2，则显示2个字段，依此类推。
thinkspi.com
0 -
Lizbet ✭
嗨,保罗,
我想过这个，但我如何在表单中自动化它，让1字段从用户指示出来，2字段。如果有必要，3,4，因为我找不到可以在自动化中添加的列，你知道如何配置自动化逻辑吗?
0 -
保罗新来的 ✭✭✭✭✭✭
它在表单构建器本身中。你可以用场逻辑。这不是自动化。
thinkspi.com
0 -
Lizbet ✭
你能告诉我在你提出的逻辑下，你将如何配置它的形式吗?我已经尝试直接从表单中完成，但我无法使用户指示其工作中心的字段链接到启用填充的字段。拜托，如果你能把你的配置截屏，这将对我有很大帮助
0 -
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
为保罗的绝妙建议/回答锦上添花。
更多信息。
那有用吗?
我希望这对你有所帮助!
注意安全，祝你有一个美好的一周!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为深刻的/投票或/和作为公认的答案．这将使其他人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
关于Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。
0 -
Lizbet ✭
非常感谢，这对我来说很有价值!
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>
