Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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!
Hi, I am wondering if there is a solution for this scenario: I have a Data Shuttle data upload workflow to a Target Sheet that is updated when a new attachment is added. Question: is there a function/features/workaround like Data Shuttle, Bridge, or a combination of features so that if a new column is added to the Excel…
I have downgraded to business but no longer have access to my sheet,i get an error 48,get licensing? How do I fix this? This is a customer contact form so i cant recreate it as the email has been sent?
I have been given access as an Admin to edit an existing sheet but cannot edit columns. I am a System Admin. I am a paid Member. I am able to edit information in the sheet but cannot add a column.
