Calculating A Formula Question
Hello Smartsheets Community:
Does anyone know why I would be getting a #INVALID when calculating a formula in a column that references two other columns with formulas in it? I thought you could calculate a formula in a column that references other columns with formulas in it? Is that not the case? Or, am I using the wrong formula? Any help would be greatly appreciated.
Best,
Anthony D'Ambrosio
Best Answer

Your [High/Med/Low Rank] column is the issue.
The formula there is not creating a number it is adding a string "5". You should be able to just change that formula to 5, 1, and 3 (without the quotation marks), and it would remove the issue with the other column.
Answers

Your [High/Med/Low Rank] column is the issue.
The formula there is not creating a number it is adding a string "5". You should be able to just change that formula to 5, 1, and 3 (without the quotation marks), and it would remove the issue with the other column.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!