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:
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.
=IF(AND([Required Weld Size]4 = 0.25, [Actual Weld Size1]4 = 0.5, 0, 1))
I am not able to get the above working. IT comes back imbalaced and I have played around with it with not luck. Can anyone lend a thought?
Wanna try this? Just guessing what you're trying to do:
=IF(AND([Required Weld Size]4 = 0.25, [Actual Weld Size]4 = 0.5), 0, 1)
Dean,
I think Jenny has your answer.
However, if the required weld was 0.5 and the actual was 0.25, that would be even worse, wouldn't it?
This would tell you when they don't match
=IF([Required Weld Size]4 = [Actual Weld Size]4, 1, 0)
1 = match
0 = no match
Note that the syntax for IF is
IF(expression,true,false)
True = 1
False = 0
If you switch them like you did
IF(expression,0,1)
bad things can happen to you. At least where I work.
Craig
