是否有一个公式编辑窗口?
是否有一个可用的公式窗口，以便我可以更好地编辑/创建长公式?当您开始键入公式时，弹出的单元格会覆盖其他单元格，使您难以在同一行中选择列。我想有一个单独的弹出窗口，我可以在屏幕上移动或使更大，这样我就可以看到和工作在一个复杂的，或长，公式更容易。
谢谢
评论
-
L_123 ✭✭✭✭✭✭
我用记事本，在中间复制粘贴。你甚至可以通过输入键将公式放到新行来分隔公式，当粘贴回智能表时，它会自动修复。
-
迈克Wilday ✭✭✭✭✭✭我同意Luke_TK——我在notepad++中完成所有冗长或嵌套的公式，它还提供了括号的高亮显示，这有助于我确保正确地关闭它们。
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭是啊，Luke_TK和Mike说的。
我用的是UltraEdit。
我还会先使用多个列构建复杂的公式，然后在测试完每个部分后再将它们组合起来。
克雷格
-
大卫•维兰德 ✭
如果公式编辑窗口没有覆盖特定行中引用的单元格，那么在审计公式时，我将非常有用。更令人沮丧的是，当您上下滚动时，公式编辑窗口会随着引用的行移动。
记事本可以很好地创建公式，但不适合编辑。
大卫
-
她名叫Stara ✭✭✭✭✭✭智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
大卫•维兰德 ✭
完成，谢谢，也祝你节日快乐!
类别
I figured out the code and here it is in case anyone is trying to do the same thing<\/p>
=IF(AND([Due Date]@row < TODAY(), Status@row <> \"Complete\"), \"Red\", IF(AND([Due Date]@row = TODAY(2), Status@row <> \"Complete\"), \"Yellow\", \"Green\"))<\/p>
Caroline<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]},{"discussionID":106475,"type":"question","name":"Applying a formula for the whole column","excerpt":"Hi! I currently have a formula for a specific cell in a row. I would like to apply that formula to all cells in the same column. I tried dragging the formula down as far as I can go, but when a new row is added from a form, it seems to add way down my sheet (not consecutively after the last entry) and the formula is not…","categoryID":322,"dateInserted":"2023-06-14T21:59:50+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T22:46:53+00:00","insertUserID":123105,"insertUser":{"userID":123105,"name":"Thu Nghiem","url":"https:\/\/community.smartsheet.com\/profile\/Thu%20Nghiem","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:37:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":123105,"lastUser":{"userID":123105,"name":"Thu Nghiem","url":"https:\/\/community.smartsheet.com\/profile\/Thu%20Nghiem","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:37:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3373564003,"url":"https:\/\/community.smartsheet.com\/discussion\/106475\/applying-a-formula-for-the-whole-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106475\/applying-a-formula-for-the-whole-column","format":"Rich","tagIDs":[204,254],"lastPost":{"discussionID":106475,"commentID":380683,"name":"Re: Applying a formula for the whole column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380683#Comment_380683","dateInserted":"2023-06-14T22:46:53+00:00","insertUserID":123105,"insertUser":{"userID":123105,"name":"Thu Nghiem","url":"https:\/\/community.smartsheet.com\/profile\/Thu%20Nghiem","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:37:22+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-15T10:29:40+00:00","dateAnswered":"2023-06-14T22:05:26+00:00","acceptedAnswers":[{"commentID":380679,"body":"
Hi there.<\/p>
<\/p>
All you have to do is right click on a cell where you have the formula and click on \"Convert to Column Formula\".<\/p>
![\"Column](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/Z9B9OAJOBFOE\/column-formula.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
