Top up a column with another column value

Moughabat

I have two columns in my sheet, one that is ACTUAL HOURS, and one that is WORKED HOURS.

Every time users enter worked hours, the workflow automation takes those hours into that user timesheet, and then clear the WORKED HOURS column so that user can re-enter other hours at any later point of time… at the end of the task (when we complete it), I want to know all the hours spent on this task, and that would be the comulative WORKED HOURS… I would like Actual Hours to be updated on the go whenever Worked Hours are added.

Ex:

Day 1-

Actual Hours = 0

Worked Hours = 5

*Missing* —> Actual Hours = 0+Worked Hours = 5

workflow clears Worked Hours —> Worked Hours = 0

Day 2-

Actual Hours = 5

Worked Hours = 3

*Missing* —> Actual Hours = 5+Worked Hours = 8

workflow clears Worked Hours —> Worked Hours = 0

SueinSpain

Only thing I can think of is to add another column for cumulative worked hours and add intothat too.

e.g. day 1 cummlative worked hours = 5

day 2 cumulative = 5 + 3 = 8 etc.

before the workflow clears the worked hours field

Moughabat

@SueinSpain - Thats exactly my plan for ACTUAL HOURS - to hold commulative hours… but how to acheive this…

When worked hours are entered, i should be able to triger workflow that sets commulative hours to commulative hours + worked hours, then clear them… right? - within workflow actions, i am not able to do that, the only action i see to update commulative hours cell is to a constant value… I really hope i am wrong …

SueinSpain

so perhaps you need a "helper" field and you cannot write a formula in a workflow as far as I know.

I'd need to think further about how I'd do this but would have the input, a formula in the smartsheet and use the automation to clear the cell.

Are they add a value inotthe same record each time or are they submitting a new record each time - for example a record for day 1, another record for day 2. I think the means of input is key as if they were inputting a new record for each day then you could use summary fields to have your cummulative totals.

Moughabat

no - its one record, as it represents a task, and every time they enter worked hours, that clears after the worked hours is added to their timesheet, and open again for another reporting.

Lets say I added another helper colmn

Moughabat

@Paul H - Looking at many comments related to similar topics made me tag you - perhaps you can help out on this… thank you anyway

Andrée Starå

https://community.smartsheet.com/discussion/136641/top-up-a-column-with-another-column-value

Hi,

I hope you're well and safe!

I'm answering here as well. I've shared an example with you.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!