Possible Issues with My formula
Good Morning everyone,
I am currently trying to set up one my sheets to be mostly automated. I have a column that is labeled "Ticket type", "price", "quantity", and "total amount". I have a IF formula set up in "price" column so if a certain ticket type appears it will populate the column with a Number. In This sheet I plan on multiplying "price" and "quantity". The issue comes when I set up a formula in the "Total amount" column to have "price" and quantity" multiplied I get #Invalid operation.I have tried using =sum, and =value. I apologize if this is an easy fix, I am new to Smartsheet.
Best Answer

Change you ticket price formula to have just the number (no quotations or currency symbols),
so
"$5.00"
changes to5
. Same for the rest...
Answers

Change you ticket price formula to have just the number (no quotations or currency symbols),
so
"$5.00"
changes to5
. Same for the rest... 
That Worked! Thank you for taking some time out of you day to answer that Leibel.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!