I need to check for the below conditions at list level and I am looking for suggestion for below conditions which needs to be determined
I am using new forms in canvas when items are created or modified so assignment date is captured automatically so in this context, I need suggestions on how to set the below counters
conditions:
1)how to set number of assignments counter per candidate in the last 12 months and throughout each calendar year per each calendar
2)how to set number of replacements counter in the last 12 months
list schema for Main list gallery dashboard
CandidateName(person field) Noofassignments(number field) Noofreplacements(number field)

Report
All responses (
Answers (