I need to know if I could "If Colum A not= Colum B" Change Colour in Colum A"
Colum A (10) Colum B(5) then Colum A should be in a colour designated.
Best Answer
-
The formula that @Andrée Starå also included a ,1) at the end, so format that column as a checkbox where you are writing the formula, in your example Help C
=IF([Column A]@row <> [Column B]@row, 1)
You would then be able to configure a conditional formatting rule where if that column is checked to highlight the row.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Answers
-
I hope you're well and safe!
Try something like this in a so-called helper column that we'd use to trigger a Conditional Formatting rule. (change the column names to match yours)
=IF([Column A]@row <> [Column B]@row, 1)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I appreciate your support, but please pardon my ignorance, I am unable to get it going. I am not sure if I am doing it correct.
-
The formula that @Andrée Starå also included a ,1) at the end, so format that column as a checkbox where you are writing the formula, in your example Help C
=IF([Column A]@row <> [Column B]@row, 1)
You would then be able to configure a conditional formatting rule where if that column is checked to highlight the row.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
Thank you So much @Colleen Patterson it works perfectly.
Thank you @Andrée Starå for all the support, I am sorry I did not get it, apologies for my ignorance.
-
@desmond_Erskine happy to be of assistance. If you would mark the answers as accepted, that would help other learners find this information in the future.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
No worries! Easy to miss!
Glad we got it working!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!