Sign in to join the conversation:
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!
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
