在计算字段中列出公式 [英] List formulas in a calculated field
问题描述
大家好，
在以下方面，我将非常感谢您的帮助.
我有一个清单，经理在每次员工迟到时都会记录下来.
我的列表包含以下内容；
1)员工姓名
[人员或组]
2)迟到日期
[日期]
3)原因不足
[是/否]
4)实例
[计算公式]
我希望第4列是一个如下所示的公式
查阅字段1)雇员姓名
计算从2)延迟日期算起的最后30个日历日中有多少次
员工有3)原因不足=否
然后在4)实例字段中返回一个数值，例如1、2、3
然后我想要做的是安排一个工作流，当触发第三个实例时(我应该可以这样做)，该工作流会通过电子邮件发送给Line Manager，但我真的在公式中苦苦挣扎.
请帮助！
在没有充分理由的情况下，无法使用计算列来计算每个员工迟到的次数在列表中.
要实现这一目标，我们可能需要代码.一个想法是，使用PowerShell迭代项目并计算数量.
有关如何使用列表管理列表项的演示 Po werShell:
如果您需要PowerShell命令 要在计划的时间自动运行，请从以下位置运行脚本 任务计划程序.
最好的问候，
Linda Zhang
Hi all,
I would really appreciate some help on the following.
I have a list that is completed by managers to record every time an employee is late.
My list contains the following;
1) Employee Name
[Person or Group]
2) Date of Late
[Date]
3) Insufficient Reason
[Yes/No]
4) Instance
[Calculated Formula]
I would like column 4 to be a formula that does as follows
Looksup at field 1) Employee Name
Counts how many times in the last rolling 30 calendar days from 2) Date of Late
That an employee has 3) Insufficient Reason = No
Then returns a numerical value in the 4) Instance field eg, 1, 2, 3
What I then want to do is arrange a workflow that emails the Line Manager when the third instance is triggered (Which I should be okay to do) but I am really struggling with the formula.
Please help!
Hi blackyuk,
It is impossible to use a Calculated column to count the times that each employee is late without insufficient reason in the list.
To achieve that, we may need code. An idea is that, using PowerShell to iterate through items and count the number.
Demoes about how to manage list items using PowerShell:
https://www.sharepointrelated.com/2012/05/03/addedit-list-items-using-powershell-in-sharepoint-2010/
If you want the PowerShell commands to be automatically run at a schedule time, run the script from Task Scheduler.
Best Regards,
Linda Zhang
这篇关于在计算字段中列出公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
