#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Formula Help

edited 12/09/19

Below is a screenshot of the sheet that I am trying to create a formula on.

What we need is a formula that will calculate the Quantity x Unit Price + Extra Charges = Total Price. BUT we only need this calculation if Fixed Quote \$ is blank. If Fixed Quote \$ IS populated then we need that value to populate in Total Price.

Any help would be greatly appreciated.

Thank you,

Brandy

Tags:

• Brandy,

I'd recommend using IF in conjunction with ISBLANK() here. Try giving it a shot with the new in app formula help.

A quick example might be:

IF(ISBLANK([Fixed Quote \$]6),[Quantity]6*[Unit Price]6+[Extra Charges]6,[Total Price]6)

• ✭✭✭✭✭

Brandy,

Here is another solution to try to achieve the same thing:

=IF([Fixed Quote \$]2 = 0, (Quantity2 * [Unit Price]2) + [Extra Charges]2, [Fixed Quote \$]2).

Whatever works best for you.

• This worked perfectly, thank you!

We also added a +[Extra Charges] to the end to include those in our final number with the Fixed Quote.

Thanks for the help.

Brandy

This discussion has been closed.