Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hi Everyone,
I am needing help with a formula.
I need it to function as =if "Wet Paint" has check mark, change "Lane Designation" to Wet Paint.
Thanks for the help in advance.
re: I need it to function as =if "Wet Paint" has check mark, change "Lane Designation" to Wet Paint.
=IF([Wet Paint]23,"West Paint","")
in row 23 of [Lane Designation].
However! If anyone changes [Lane Designation] manually, the formula will be overwritten (gone).
You will need to (if you can), expand your IF used NESTED IF's. For example
=IF([Wet Paint]23,"West Paint",IF([Powder Paint]23,"Powder Paint","and so on")
Order is important - the system checks left to right and then stops when it finds a result. If both of those columns are checked, it will result in "Wet Paint".
I hope this helps.
Craig
