Just getting back into Smartsheets as its been a while with another company. Current company is migrating to Smartsheet after running VERY manual processes (YAY!)
My current head-scratcher:
I have a need to track cable installation footages by three categories: This Week, Last Week and To Date. Currently its VERY manual as we transition to Smartsheet - add This Week totals to To Date column then moving it to the Last Week column to the next reporting period (Weekly). The Last Week totals are strictly a holding column and used to visually see last week's reported totals.
What I have been trying unsuccessfully to do is to have a formula that would take the total input into this week and have it auto-update the To Date column when a footage is entered into the This Week cell. This would need to be done for all rows as I track on a per-job basis.
I am looking for the best approach to accomplish this. I tried to do this in excel and asked in forums there as well. I was told that there is not really a formula to do that, but a button could be crewed with code to accomplish what I want. If this is the case with Smartsheet, can a form be used to input the footages and update the column? This may actually be a better route as multiple people provide the data on specific jobs, so having them submit a form may be an option.
Any ideas/assistance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!