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
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
Comments
-
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