Forum Discussion
Beyondforce
9 years agoHelper I
IF statment doesn't work!
Hey Guys, I'm trying to add a new column and I'm also adding this formula, but it's not working! What's wrong with it? =IF([LateStart]= 0, && ([LateEnd] = 0),0)) Thanks. Ben.
- 9 years ago
Beyondforce
9 years agoHelper I
I have 2 columns with 1 and 0. In the new column I want to create 4 option:
LateStart LateEnd Status
0 0 0
1 0 1
0 1 2
1 1 3
I need to use the IF and AND statment to create the result in the "Status" column. Later I'll use a color condition for all the 4 number options in the Status column.
Vvelarde
9 years agoCommunity Champion
- Beyondforce9 years agoHelper I
In here:
- Vvelarde9 years agoCommunity Champion