OOTB sharepoint list level column validation

sweetu ve 281

My list has below columns

Staffs lists

Counter ->Number data type columns
No of replacements ->Number data type column
status -choice field

here is the scenario:(requirement) and we have to determine if any columns that would be needed for the below criteria to resolve the same.

1) status ACTIVE is assigned automatically for a duration of a natural year when the assignment takes place

2)A counter will be available with the number of assignments in the last 12 months and throughout each calendar year ,per each staffs and for the whole staffs lists ???

query 1:How to validate counter getting incremented?

3)No of replacements counter will be available with the number of replacements taking place in the last 12 months.

query 2: How to check for no of replacements counter ?

using OOTB list level column validations or any other approaches please help

Joyce Shen - MSFT 16,641 Reputation points

2022-11-14T01:33:55.307+00:00

Hi @sweetu ve

Thanks for visiting our forum, according to your description above, your issue is more related to SharePoint, so I will help you modify the tag to the correct one, thanks for your understanding and hope your issue can be resolved soon!
Yanli Jiang - MSFT 21,361 Reputation points Microsoft Vendor

2022-11-14T10:35:44.133+00:00

Hi @sweetu ve ,
Thanks for your question!
I have read your question carefully, and I need to confirm with you the following information:
1,What version of SharePoint are you using?
2. Status is a column of choice, how to achieve what you said "status ACTIVE is assigned automatically for a duration of a natural year when the assignment takes place"?
3. Does the value in the counter column refer to the sum in the natural year corresponding to when the Status is active?
4. Is there a range limit for the years in "A counter will be available with the number of assignments in the last 12 months and throughout each calendar year"? The growth trend must have a time frame, such as the past 3 years.
5. How to express the result of growth?
6,"No of replacements counter will be available with the number of replacements taking place in the last 12 months.
query 2: How to check for no of replacements counter ? " I don’t quite understand the meaning of this sentence, how do you need to check? What kind of result do you want to achieve?
For the above problems, please give detailed information so that we can give better support. If possible, suggest some handwritten schematics.
Thank you for your understanding and support!
Yanli Jiang - MSFT 21,361 Reputation points Microsoft Vendor

2022-11-18T02:43:41.26+00:00

Hi @sweetu ve ,
Any update? If there is any progress, please feel free to contact us.
Yanli Jiang - MSFT 21,361 Reputation points Microsoft Vendor

2022-11-23T08:07:42.817+00:00

Hi @sweetu ve
Again, to solve your problem, I need to confirm with you the following information:
1, What version of SharePoint are you using?
2. Status is a column of choice, how to achieve what you said "status ACTIVE is assigned automatically for a duration of a natural year when the assignment takes place"?
3. Does the value in the counter column refer to the sum in the natural year corresponding to when the Status is active?
4. Is there a range limit for the years in "A counter will be available with the number of assignments in the last 12 months and throughout each calendar year"? The growth trend must have a time frame, such as the past 3 years.
5. How to express the result of growth?
6,"No of replacements counter will be available with the number of replacements taking place in the last 12 months.
query 2: How to check for no of replacements counter ? " I don’t quite understand the meaning of this sentence, how do you need to check? What kind of result do you want to achieve?
For the above problems, please give detailed information so that we can give better support. If possible, suggest some handwritten schematics.
Thank you for your understanding and support!