Date field to determine reset date 1 year in the future

[kchmiel1]

Hello!  I am trying to solve a problem but am having no luck.  I have a SharePoint list reimbursement requests.  I have a canvas app to display the information for the requests based on who is logged in (so if I open the app, it only shows my submissions). Each employee gets $150 per 12 months, and the 12 month clock starts on their first submission.  So if I submit no 6.6.23 for $75, I have $75 to use before 6.5.24.  I want to add a field that will tell me when the the reset date is based on the date of the first submission.  The field I have is Date Paid, which displays the date on which the payments are made to the employees, but they can submit multiple, so I need to new field to look through all of the submissions, find the first one, and add 365 days to that and display that date.  Is this possible?

[MudassarSZ365]

Create a New Calculated Column:

In your SharePoint list, create a new calculated column, let's call it "Reset Date."

Write the Calculation Formula:

In the formula for the "Reset Date" calculated column, you'll need to use SharePoint's calculated column functions to find the date of the first submission and add 365 days to it. Assuming your columns are named "Employee Name" and "Date Paid," you can use a formula like this:

=MIN(IF([Employee Name]=[@[Employee Name]],[Date Paid]))+365

Save the Calculated Column:

Save the calculated column, and SharePoint will calculate the reset dates based on the first submission date for each employee.

Kindly mark the solution as accepted if it resolves your issue.

Best Regards
Muhammad Mudassar Mazhar

[kchmiel1]

Thank you, but I don't think I'm describing it correctly - I've included pictures.  I want to display the Reset Date in the canvas app (1st picture). The 2nd picture is my SharePoint list with 3 examples of the data.  I want the canvas app field that is highlighted in blue to look at the gallery (or the SharePoint list), find the first submission and add a year to it - then display that data in the canvas app.  If I add a calculated column to the SharePoint list, won't it simply add a year to each row, rather than calculating by person, not by each submission?