Conditional Dashboard Formating?

I have a sheet with several rows, and those rows may or may not have sales orders. If the row has a sales order then its booked, if it doesn't then it's pipeline.

I'd like to have a dashboard pull data from this sheet that adds up all of the rows that contain an SO and also add up all the rows that don't have an Sales Order number.

So basically

if Sales order is blank, then pull the amount from the "dollars field" and use it for the sum of the sales pipeline

If Sales order field is populated, the pull the total "dollars field" and use it for the sum of the "booked" orders

Is there an easy way to do this?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!