你能自动隐藏/取消隐藏列吗?

Davyn
Davyn ✭
在公式和函数

是否有一种方法可以根据前一列中的数据自动隐藏和取消隐藏列?即使是通过自定义集成?

· 在Facebook上分享 在Twitter上分享

最佳答案

答案

帮助文章参考资料欧宝体育app官方888

在智能表中创建和编辑公式

交叉表引用的公式组合

智能表功能列表

类别

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!
0.01, [% Complete]@row…","categoryID":322,"dateInserted":"2022-11-10T23:19:23+00:00","dateUpdated":"2022-11-10T23:35:16+00:00","dateLastComment":"2022-11-12T22:33:02+00:00","insertUserID":154851,"insertUser":{"userID":154851,"name":"Jodi C","url":"https:\/\/community.smartsheet.com\/profile\/Jodi%20C","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5qlOufSjfDo!xBtOMYTHJno!KTQ5OLC8XX5","dateLastActive":"2022-11-12T22:30:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":154851,"lastUserID":154851,"lastUser":{"userID":154851,"name":"Jodi C","url":"https:\/\/community.smartsheet.com\/profile\/Jodi%20C","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5qlOufSjfDo!xBtOMYTHJno!KTQ5OLC8XX5","dateLastActive":"2022-11-12T22:30:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":35,"score":null,"hot":3336415945,"url":"https:\/\/community.smartsheet.com\/discussion\/97635\/combining-if-and-if-and-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97635\/combining-if-and-if-and-formulas","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":97635,"commentID":350976,"name":"Re: Combining IF and IF AND Formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350976#Comment_350976","dateInserted":"2022-11-12T22:33:02+00:00","insertUserID":154851,"insertUser":{"userID":154851,"name":"Jodi C","url":"https:\/\/community.smartsheet.com\/profile\/Jodi%20C","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5qlOufSjfDo!xBtOMYTHJno!KTQ5OLC8XX5","dateLastActive":"2022-11-12T22:30:14+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":"2022-11-12T22:32:44+00:00","dateAnswered":"2022-11-11T15:41:39+00:00","acceptedAnswers":[{"commentID":350857,"body":"

Hi @Jodi C<\/a>,<\/p>

I automated my Status column the same way using this.<\/p>

=IF([% Complete]@row = 0, \"Not Started\", IF(AND([% Complete]@row >= 0.01, [% Complete]@row < 1), \"In Progress\", \"Complete\"))<\/p>

Hope this helps!<\/p>

BRgds,<\/p>

-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-12 22:32:44","updateUser":{"userID":154851,"name":"Jodi C","url":"https:\/\/community.smartsheet.com\/profile\/Jodi%20C","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5qlOufSjfDo!xBtOMYTHJno!KTQ5OLC8XX5","dateLastActive":"2022-11-12T22:30:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":97667,"type":"question","name":"Using a Form to input a row into a grid","excerpt":"I created a Form to enter a new row of data into a grid type sheet. The form setup was straightforward and worked fine except when it input the new row into the grid, it left a blank line between the last row and the new row created by the form. I tried it again and this time it left several blank lines between the bottom…","categoryID":322,"dateInserted":"2022-11-11T19:58:20+00:00","dateUpdated":null,"dateLastComment":"2022-11-11T20:11:30+00:00","insertUserID":154725,"insertUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T20:10:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154725,"lastUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T20:10:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3336395390,"url":"https:\/\/community.smartsheet.com\/discussion\/97667\/using-a-form-to-input-a-row-into-a-grid","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97667\/using-a-form-to-input-a-row-into-a-grid","format":"Rich","tagIDs":[319],"lastPost":{"discussionID":97667,"commentID":350912,"name":"Re: Using a Form to input a row into a grid","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350912#Comment_350912","dateInserted":"2022-11-11T20:11:30+00:00","insertUserID":154725,"insertUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T20:10:49+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":"2022-11-11T20:11:40+00:00","dateAnswered":"2022-11-11T20:09:41+00:00","acceptedAnswers":[{"commentID":350911,"body":"

@Chadd<\/a> <\/p>

Some times when making changes to a sheet, writing formulas does it a lot, it will look like a row is blank but it is not. Then a form or a move\/copy row will add rows with blank rows above them. To fix this, simply highlight the first empty row and then shift-select the final row at the bottom of the sheet. Then delete them all. Then when you refresh the sheet it will add about 10 blank rows at the bottom.<\/p>

That should stop the blank rows you're getting. At least until you do something that accidentally adds blank rows again like writing another formula without deleting the row you wrote it in.<\/p>"},{"commentID":350912,"body":"

Got it - Thank you!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 20:11:40","updateUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T20:10:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":319,"urlcode":"functionality","name":"functionality"}]},{"discussionID":97661,"type":"question","name":"is there an easier way to format a cell to read blank if value is 0?","excerpt":"i have a large report with many countifs to calculated data over time. I want to change it so that instead of displaying the 0 when the formula calculates a 0 the cell is just left blank. I've been using If statements but the formula is so long i wonder if there is an easier way. for example I might use…","categoryID":322,"dateInserted":"2022-11-11T19:02:41+00:00","dateUpdated":null,"dateLastComment":"2022-11-11T20:08:09+00:00","insertUserID":154873,"insertUser":{"userID":154873,"name":"Angela B","url":"https:\/\/community.smartsheet.com\/profile\/Angela%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T21:22:38+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-11-12T17:23:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3336391250,"url":"https:\/\/community.smartsheet.com\/discussion\/97661\/is-there-an-easier-way-to-format-a-cell-to-read-blank-if-value-is-0","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97661\/is-there-an-easier-way-to-format-a-cell-to-read-blank-if-value-is-0","format":"Rich","lastPost":{"discussionID":97661,"commentID":350910,"name":"Re: is there an easier way to format a cell to read blank if value is 0?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350910#Comment_350910","dateInserted":"2022-11-11T20:08:09+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-11-12T17:23:23+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":"2022-11-11T20:32:13+00:00","dateAnswered":"2022-11-11T20:08:09+00:00","acceptedAnswers":[{"commentID":350910,"body":"

That's really the only way to do it. You can copy\/paste the COUNTIFS portion though to avoid having to type it out twice.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 20:32:13","updateUser":{"userID":154873,"name":"Angela B","url":"https:\/\/community.smartsheet.com\/profile\/Angela%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T21:22:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">