Sum based on multiple conditions

i am trying to sum a column based on multiple criteria. Example

If "Capital Proposal C&D Cost" column is blank, I want to set "Total Project Cost" Column = "Final Roadmap Value" column + "Estimated C&D Cost" column

Else, I want to set "Total Project Cost" Column = "Final Roadmap Value" column + "Capital Proposal C&D Cost" column

Any advise on how to do this is much appreciated!!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!