Hello! New to Smartsheet and attempting to do something I think is easy, but I can't noodle through. Here is the problem statement:
Two columns: Allocation and Hrs/week. I need the Hrs/week to automatically adjust when Allocation is adjusted up/down. For example, 40 hour week and the allocation is set to 1. When allocation is adjusted to .5 it will automatically halve the hours to 20 hours.
Help Article Resources
Check out the Formula Handbook template!