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

Brandy S. PVD
edited 12/09/19 in Archived 2017 Posts

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,


Recap Screenshot.PNG



This discussion has been closed.