Is there a way to perform addition to an integer via an automation, workflow, or a formula?
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.
Answers
-
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?
-
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.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives