Forum Discussion
JeremyCohen2
5 years agoQrew Trainee
So what your suggesting is a separate table for this information that ties to each year?
How could i separate that by each record would it be more like...
"Record Name", "Process Information", "Year it ties to" as 3 separate fields? then wouldn't the unique ID end up becoming just as cumbersome?
I created a nested if statement to include the variances which ended up quite astronomical just to include 3-4 years of data. Was hoping for a way to keep it searching so that anyone in the future could add a new field for the new year and it would just automatically populate the data correctly.
Would it work to have a case within the brackets...for instance "["&Year(today())&"]"
This would involve something similar to the "indirect" formula within excel
How could i separate that by each record would it be more like...
"Record Name", "Process Information", "Year it ties to" as 3 separate fields? then wouldn't the unique ID end up becoming just as cumbersome?
I created a nested if statement to include the variances which ended up quite astronomical just to include 3-4 years of data. Was hoping for a way to keep it searching so that anyone in the future could add a new field for the new year and it would just automatically populate the data correctly.
Would it work to have a case within the brackets...for instance "["&Year(today())&"]"
This would involve something similar to the "indirect" formula within excel