If this, then that formula question
Hello! this may be so simple, but I'm having a hard time with it.
I want a few things to happen 
if the Approx trips per year is blank:
provide the sum of just the Registration price field & the Approximate travel field
If the Approv trips per year is NOT blank:
multiply the approx trips per year by the apprx travel cost, then provide the sum of that travel cost and the Registration price
it feels like an if statement, but I always have a hard time with the NOT blank if statements.
Best Answer

That said, a more linear, spoken version of the formula would look like this:
=if(isblank([approximate trips per year]@row),[registration price]@row + [approximate travel cost]@row,[registration price]@row + [approximate travel cost]@row * [approximate trips per year]@row
The first one is just smaller and more efficient by reducing the number of references.
Answers

=[Registration Price]@row + [Approximate Travel cost]@row * if(isblank([Approximate Trips per year]@row),1,[Approximate Trips per year]@row
that should do it for you.

That said, a more linear, spoken version of the formula would look like this:
=if(isblank([approximate trips per year]@row),[registration price]@row + [approximate travel cost]@row,[registration price]@row + [approximate travel cost]@row * [approximate trips per year]@row
The first one is just smaller and more efficient by reducing the number of references.

That second one worked, thank you!
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!