The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hello airtablers,
I have a field {RESPONSE} with 5 possible choices A,B,C,D,E
I need to be able to give a score based on each response.
So if response is A OR B score is 4
if response is C OR D score is 1
if response is E score is 3
This would be e...
Hi All,
I am trying to go around this nested formula and hope someone could help me try understand why is not working.
I have three {columns} that indicate if a condition is either 1 or 0.
So:
column 1 can be 1 or 0
column 2 can be 1 or 0
column 3 ca...
I thing I have solved it :laughing:
IF(A2=0,”STATUS B”,IF(AND(A2=0,A3=0),”STATUS A”,STATUS C”))
Sometimes you pursue a direction to find a solution and miss the easier way!
Leave here for reference :slightly_smiling_face:
Really great community b...