Welcome!

Conditional Formatting - conditions in one row apply to another

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

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.

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

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!

Using single-sign-on with external partners
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Anyone have the link to register for the Core Product Exam without the Learning Pass.
Cant find this anywhere