Is there a way to perform addition to an integer via an automation, workflow, or a formula?

Walter Kerfoot

I have a worksheet that tracks yearly tasks for technicians for potential raises or to track areas of focus.

The problem: I need to track how many years a technician has met all the yearly checks. If they do then we want to perform add 1 onto their [Years Complete] value.

[Current Year Potential] is a basic formula that does the following =SUM(1, [Years Complete]@row)

So ideally I would need to change the [Years Complete] to be replaced with [Current Year Potential]'s value. So that way whenever a yearly workflow triggers it would copy the [Current Year Potential]'s value over the [Years Complete] value. The formula for [Current Year Potential] would then increase by 1. However, I am not sure what is the best way to achieve this as for workflow tasks I only have the change cell value to work with. I could work around this with an workflow that has conditions to say if [Current Year Potential] = 0 Then change cell value 1, 1 to 2, so on and so forth, but that would be a rather long workflow conditional path line.

I would love to hear your feedback and ideas on how to best accomplish this task. I am more than fine going the workflow route if needed as our current business processes examines the last 3 years of data for potential raises . Though we have scenarios where we have employees who have been here for more than 10 years and I would not like to keep adding onto a conditional path if it can be avoided.

Carson Penticuff

Are you collecting yearly information somewhere? Is there a source sheet where you could do a COUNTIFS() to see how many years each tech has achieved their goals?

Genevieve P.

Hey @Walter Kerfoot

There currently isn't a workflow that can copy/paste data from one column to another in the same sheet. Please add your vote and voice to this Product Idea to let our Product team know this is a feature you would find useful: Workflow enhancement - copy a column/cell to another column/cell

I agree with @Carson Penticuff - how are you getting the original "Years Complete" data? You could have a formula that counts how many years from when someone started + now, then add the 1 on to that as part of the same formula if they have passed the goals you want.