Help with Bulky Formulas/Formatting?

@emipathy ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi all, 

I'm fairly new to smartsheet (with no Excel experience either). Here's my situation. 

I'm tracking POs-- first, you enter in a PO amount, and in subsequent columns what you invoice per-month. There's a final "Totals" column that sums up your monthly invoices. 

Currently, I have a hidden column set up to test if PO Total = Totals, using this formula: 

=(IF ([PO Total]2 = Totals2, "1", "0"))

Then I have Conditional Formatting set up (see screenshot).

Without the first line of conditional formatting, rows with Blank POs that match Black Totals will highlight green and it is just confusing. 

My question is... is there any way to clean this up and condense it? Because I'm not expert level, I feel like all of this is clunky, and setting it up on 8+ sheets is a bit time consuming. 

Any insight would be extremely appreciated! 





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!