SharePoint 2010中的计算列 [英] Calculated columns in SharePoint 2010
问题描述
我的公司正在使用SharePoint2010.我创建了一个文档库来存储存档文件，并且正在使用元数据对这些文件进行排序，筛选和分组.我想创建的列是由日期决定的文本值；一个是合同名称，另一个是 表演期间.我希望使用计算所得"列，而不是使用数据表视图将新数据输入到所有这些文件中(分别确定这些文件属于哪个合同/期限).我的如果"都不是公式产生 结果(下面的示例).
My company is using SharePoint 2010. I created a document library to house archived files and I am using metadata to sort, filter, and group these files. The columns I wanted to create are text values decided by dates; one is Contract Name and one is Period of Performance. Instead of using Datasheet view to then enter this new data into all of these files (an individually decide to which contract/period these files belong), I was hoping to do a Calculated column. None of my "if" formulas yielded results (examples below).
自2012年以来，我们有3个合同名称.在每个合同中，都有不同的履约期限(PoP)，例如BY(基准年)，Option Year 1(OY1)，依此类推.我希望在日期介于mm/dd/2012-mm/dd/2014之间时填写合同名称. 等等.并根据其修改日期填充PoP.这是我尝试创建显示BY(基准年)的公式的尝试:
We had 3 contract names since 2012. In each of those contracts, there were different periods of performance (PoP), e.g. BY (Base Year), Option Year 1 (OY1), and so on. I wanted the Contract names to populate when the dates were between mm/dd/2012 - mm/dd/2014.. and so on. And for the PoP to populate based on its Modified date. Here are my attempts at creating a formula to show BY (Base Year):
= IF(OR([Modified] = 41179:41543，41909:42273，43132:43190)，"BY")
=IF(OR([Modified]=41179:41543, 41909:42273, 43132:43190), "BY")
= IF(AND([Modified]> = 41179，< = 41543，"BY"))
= IF(AND([Modified]> = 41909，< = 42273，"BY"))
= IF(AND([Modified]> = 43132，< = 43190，"BY")
=IF(AND([Modified]>=41179, <=41543, "BY")
=IF(AND([Modified]>=41909, <=42273, "BY")
=IF(AND([Modified]>=43132, <=43190, "BY")
(以上:使用Excel中的日期值的第一个和第二个示例)
(Above: 1st and 2nd examples using the date values from Excel)
= IF(AND([Modified]> = 9/27/2012，< = 9/26/2013，"BY"))，
= IF(AND([Modified]> = 9/27/2014，< = 9/26/2015，"BY"))
= IF(AND([Modified]> = 2/1/2018，< = 3/31/2018，"BY")
=IF(AND([Modified]>=9/27/2012, <=9/26/2013, "BY"),
=IF(AND([Modified]>=9/27/2014, <=9/26/2015, "BY")
=IF(AND([Modified]>=2/1/2018, <=3/31/2018, "BY")
= IF(OR([Modified] = 9/27/2012:9/26/2013，9/27/2014:9/26/2015，2/1/2018:3/31/2018)，" ; BY)
=IF(OR([Modified]=9/27/2012:9/26/2013, 9/27/2014:9/26/2015, 2/1/2018:3/31/2018), "BY")
(以上:使用实际书面日期的第3和第4个示例)
(Above: 3rd and 4th examples using actual written dates)
这些都不起作用.
然后，我尝试创建一个名为Performance of Performance的列表，该列表包含3列:标题，开始日期，结束日期.我使用计算公式创建了一个名为绩效期"的第四列: = IF(AND(Mod(修改> = [开始日期]，修改< = [结束日期])，标题)
Then I tried creating a List, entitled Periods of Performance, that had 3 columns: Title, Start Date, End Date. I created a 4th column entitled Period of Performance with the calculated formula: =IF(AND(Modified>=[Start Date],Modified<=[End Date]),Title)
现在，我希望使用此PoP列通过查找列"选项在我的存档文档库中产生值.因此，在存档"文档库中，我添加了一个PoP列:
Now I was hoping to use this PoP column to yield values in my Archive document library by using the Lookup column option. So in the Archive document library, I added a PoP column:
但该列中没有任何值.
But no values appear in the column.
请帮助..我不知道该怎么办.如果我有一个基本公式，那么我可以为这三个合同中的每一个继续执行BY，OY1，OY2，Bridge，Extension和PO.我可以为3个合约公式填写一栏吗?一栏为x金额(可能 11)PoP公式?
Please help.. I don't know what else to do. If I have a base formula, then I can continue for BY, OY1, OY2, Bridge, Extension, and POs for each of the 3 contracts. Could I do one column for 3 contract formulas? And one column for x amount (possibly 11) of PoP formulas?
推荐答案
KOST_2018，
我对您不太了解，请提供有关您列表的屏幕截图，并用图片描述问题.
Hi KOST_2018,
I am not very understanding of you, please offer a screenshot about your list and describe the problem with pictures.
此外，了解 以下文章中有关c 计算字段公式的IF函数:
Besides, learn about IF function from the following article about calculated field formulas:
最好的问候，
Lisa Chen
Lisa Chen
这篇关于SharePoint 2010中的计算列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
