自动填补空白

摄影记者罗伯特。 ✭

03/07/16 编辑12/09/19 在2016年发布的文章

下午好,

我想知道是否有可能通过使用公式中的代码来自动填充空白。例如:

代码5678 -沃尔玛商店

当自动输入代码时，空白将被填充。

这可能吗?

问候,

标签:

0 ·

基督教的井 ✭✭

03/07/16

如果你说的是在一个领域进入5768然后在另一个领域拥有沃尔玛。这将只可能与最多几个条目使用If计算。

=如果(细胞=“5768”,“沃尔玛商场”,如果细胞=“数字”、“文本 ", ..........) )

对于任何超过几个(我认为7)没有解决方案(我知道)在smartsheet。

在smartsheet中没有这样的列表验证或查找。

…你可以导出到excel做你需要的，然后重新加载。

0 · 在Facebook上分享在Twitter上分享
前提Bartal ✭✭✭✭✭✭

03/08/16

又一次投票支持动态列表？

0 · 在Facebook上分享在Twitter上分享

这次讨论已经结束了。

类别

I understand. At least the font is a little different than the rest of the form. Maybe send it out to a small test group and get their feedback. Sometimes I'm my own worst critic when it comes to setting this stuff up for others.<\/p>

\n \n $\"image.png\"$ <\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":106229,"type":"question","name":"Invalid Data Type - trying to return 1 value for multiple field scenarios","excerpt":"Here's the formula that is currently returning the Invalid Data Type error...haven't had much experience writing more advanced or nested formulas so welcome any help! =IF(AND([Build Approved]@row = 1, \"Build Approved\", \"Design\"), IF(AND([Install Complete]@row = 1, \"Installed\", \"Build Approved\")), IF(AND([In Production]@row…","categoryID":322,"dateInserted":"2023-06-08T19:33:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T20:33:35+00:00","insertUserID":162220,"insertUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T21:34:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137019,"lastUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-06-08T20:32:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":34,"score":null,"hot":3372511638,"url":"https:\/\/community.smartsheet.com\/discussion\/106229\/invalid-data-type-trying-to-return-1-value-for-multiple-field-scenarios","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106229\/invalid-data-type-trying-to-return-1-value-for-multiple-field-scenarios","format":"Rich","lastPost":{"discussionID":106229,"commentID":379720,"name":"Re: Invalid Data Type - trying to return 1 value for multiple field scenarios","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379720#Comment_379720","dateInserted":"2023-06-08T20:33:35+00:00","insertUserID":137019,"insertUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-06-08T20:32:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T19:55:54+00:00","dateAnswered":"2023-06-08T19:47:07+00:00","acceptedAnswers":[{"commentID":379708,"body":"

@dhawkins<\/a> Try the formula below and let me know if that works. The AND function is a comma separated list of conditions, and always returns only True or False. <\/p>

=IF(AND([Build Approved]@row = 1, [Install Complete]@row = 1, [In Production]@row = 1), \"In Production\", IF(AND([Build Approved]@row = 1, [Install Complete]@row = 1, [In Production]@row = 0), \"Installed\", IF(AND([Build Approved]@row = 1, [Install Complete]@row = 0, [In Production]@row = 0), \"Build Approved\", \"Design\")))<\/p>"},{"commentID":379709,"body":"

=IF([Build Approved]@row = 0, \"Design\", IF([Install Complete]@row = 0, \"Build Approved\", IF([In Production]@row = 0, \"Installed\", \"In Production\")))<\/p>

欢迎来到Smartsheet论坛档案

自动填补空白

评论

类别