If-Then statements?

W

west

We are trying to build some forms that need to be in sequential
order. Is there a function or script to set up sequential numbering
for a cell? We also have a couple forms with some If-Then statements,
but it will only perform the function on certain statements. So the
question with that would be 'Can you do multiple rules on If-Then
statements?' For example: if contractor equals BIZNAME and if the
test equals TCLP then the cost equals $55. This works great until you
change the contractor in the first if statement, even though a new
rule has been set up for the other contractor. Any thoughts?
 
B

Ben Hamlin

Yes, you can have multiple rules. Each rule would have its own condition on
which it would run. Keep in mind that rules run when the field they are on
changes - so if you want something to update when you change either field
you'll need to put the rule(s) on both.
 
Top