Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Same Varibale Function and having all rows with an entry that have a entry that match being formated
I wondering if there is a way to have conditional formating based on if the variable in a column that is the same as another.
For example.
I want one column to have a decision option. Yes, No.
If its yes, and the Applicant column has the same name in it, all rows with that name will turn to yes in the Decision Colomn
Hope this question makes sense.
Comments
-
Matt
I think your requirement is quite achievable using a fairly complex set of formulae rather than Conditional Formatting it is Conditional Logiic.
You need someone who is a real wizz at complex formulas with time to work this through with you. i'll see if one of my (formula wizard) colleagues has a chance to look at this.
Richardr
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- 10.9K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives