What If Formula / Goal Seek?
I know we aren't supposed to compare Excel to SS, but I'm not finding success in my help search.
In Excel, there is a function in the Data Ribbon labeled (Forecast) WhatIf Analysis  it has 3 drop down selections: Scenario Manager  Goal Seek  Data Table
I am really interested in the Goal Seek option which allows you to select a cell, enter what you want the calculation to equal and then click a 2nd cell that allows for the change. My example has to do w/ % reduction.
Does SS have this option or even a formula workaround?
Any Help would be appreciated. I'm sharing screenshots of the selections. Not everyone is familiar w/ this tool w/in excel.
Answers

No. You have to know what you're doing in SmartSheet to create the proper math formula to make things work correctly.

Hi @liz.mayeux
As Mike noted, there isn't a builtin window in Smartsheet where you can do this directly, however I'm sure we can get there with formulas! See: Create and Edit Formulas in Smartsheet
If I'm understanding you correctly, you want to be able to lock in a specific number in one cell and then have the two cells above it autocalculate the percentage difference between that and a different number (including the numerical value of the percentage).
Is your Smartsheet set up the same way as your Excel sheet, with the values all listed down one column? If so, you could use formulas like this:
Note that I've applied different formatting from the toolbar menu at the top to get the $ sign or %, depending on what's needed for that cell.
However if you have a lot of values to do this with, I would actually suggest adjusting your sheet format so those are columns instead of rows. This will allow you to apply formatting to the entire column and use column formulas for your calculations:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
This is fascinating. I will put it to use while building out my sheets this week and let you know.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!