nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Conditional Formatting - conditions in one row apply to another

Betsy Green

Hi, everyone.

I'd like to apply conditional formating with these parameters...

If row 3 is 100% complete, turn row 4 green.

Can this be done?

Thanks,

Betsy

Find more posts tagged with

Comments

Brian W

You could add a helper column that checks if the row above is 100% complete. For example in row 4 you could add:

=IF([% Complete]3 = 1, 1)

Then you can add a conditional format to turn the row green if the helper column equals 1.

Paul Newcome

I second Brian's suggestion. That's the only way I could think to do it.

Betsy Green

I came up with a similar solution. I added a column that is just an = for my % complete on the prior row, then formatted it accordingly.

Thank you both for the response!

Sign in to join the conversation!

Quick Links

Trending discussions

Smartsheet and Excel
Can excel sheet be used as a reference in Smartsheet?
Why does Smartsheet show the following "You have 4 days left on your business trial plan"
I have a State account
Forms only for new row items?
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt