列公式不显示在甘特图上
大家好！
我有一列由“到期日期”和另一组被称为“延期日期”的日期组成。我在“到期日”一栏中添加了公式“=IF([Extension Approval Status]@row = "ENABLED"， [Extension Date]@row)”，如果已经进行了延期并且已经获得批准，那么“延期日”将取代“到期日”。
但是，当将公式输入到转换后的列公式中时，它会去掉所有以前的到期日期，并且不允许我在甘特图上选择“到期日期”。它也不允许在提交新表单时在网格中记录新的到期日期。
这是一个错误还是有一个解释这种行为?
有解决的可能吗?
答案
-
乔有关的 ✭✭✭✭✭✭ -
Sahand ✭ -
保罗。麦吉尼斯 ✭✭✭✭✭✭抱歉，只是根据你提供的描述，如果过期日期列中的公式是列公式，如果不将其更改为单元格公式，则不允许您手动修改/过键入。
通常，您需要单独的列来包含您需要在公式中引用或拉回列公式的任何数据/信息。
下面的红色列是一个列式公式，只能运行公式，所以你需要在其他列中进行修改，这样公式就可以拉出你想要的信息。
主日期列中的公式为
=IF([延期批准状态]@row = "ENABLED"，[延期日期]@row，[到期日期]@row)
使用列公式时要记住的一些东西，希望能有所帮助
如果这与您的问题无关，请道歉，它似乎只是由描述。
谢谢
保罗
帮助文章参考资料欧宝体育app官方888
类别
The problem I was having with something similar to what you have is that it wasn't picking up projects that started before the quarter and ended after the quarter. So if project started in 2022Q4, continued in 2023Q1, and ended during 2023Q2, I would want a \"1\" for all three quarters but it was only giving me one for 2022Q4 and 2023Q2 (skipping 2023Q1).<\/p>
I actually just got this working late last night (with the help of ChatGPT). Here is what I ended up with. This one checks for 2022Q1.<\/p>
=IF(OR(AND($Start@row <= DATE(2022, 3, 31), $End@row >= DATE(2022, 1, 1)), AND(DATE(2022, 1, 1) <= $End@row, DATE(2022, 3, 31) >= $Start@row)), 1, 0)<\/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":106224,"type":"question","name":"Simple Sum question","excerpt":"This is a simple one but just having a hard time getting it to work. I have multiple clients who purchase a variety of products per invoice. I need a Sum of the Product Type per Client. I've attached an image. For example, I'd like to know Sum of Product 1 for Client 1. In this case the running total =5. I realize I could…","categoryID":322,"dateInserted":"2023-06-08T18:35:50+00:00","dateUpdated":"2023-06-08T18:41:54+00:00","dateLastComment":"2023-06-09T14:01:57+00:00","insertUserID":152073,"insertUser":{"userID":152073,"name":"jedelman","url":"https:\/\/community.smartsheet.com\/profile\/jedelman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:59:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":152073,"lastUser":{"userID":152073,"name":"jedelman","url":"https:\/\/community.smartsheet.com\/profile\/jedelman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:59:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3372569867,"url":"https:\/\/community.smartsheet.com\/discussion\/106224\/simple-sum-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106224\/simple-sum-question","format":"Rich","tagIDs":[254,334],"lastPost":{"discussionID":106224,"commentID":379823,"name":"Re: Simple Sum question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379823#Comment_379823","dateInserted":"2023-06-09T14:01:57+00:00","insertUserID":152073,"insertUser":{"userID":152073,"name":"jedelman","url":"https:\/\/community.smartsheet.com\/profile\/jedelman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:59:15+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-09T14:01:33+00:00","dateAnswered":"2023-06-08T18:45:45+00:00","acceptedAnswers":[{"commentID":379689,"body":"
This formula should work:<\/p>
You would use somethign along the lines of:<\/p>
=COUNTIFS({CoCode}, $[Column7]@row, {Status.}, [Column8]$15)<\/p>
