Apparently SmartSheet is not as smart as Excel in the Goal Seek department. I don't see any feature that allows you to enter an intended value in a cell with a formula and have the package try different values in a dependent cell until it replicates the desired value. Can someone comfirm this is not an option in SmartSheet?
Any ideas for work-arounds?
Help Article Resources
Check out the Formula Handbook template!