Help with formula

Platform discussions Special workflows & use cases
1

Hello I have a nested formula below, whicnI want to return a yes or nothing. However I cannot get it to work. I have tried with IF, IF(AND, but cannot get the result I need. Any help appreciated.

FYI - all columns referenced are check boxes, except for last two which are status

IF ({App Form}=TRUE, {Costume}=TRUE, {Costume}=TRUE, {In Keeping}=TRUE {Num Students}=TRUE, {3mins}=TRUE, {Disciplines}=TRUE, {Rules}=TRUE, {Tap}=Yes, {Status}=Yes,“Yes”," ")

2

@eddiedredge

This should do it:

IF(AND({App Form}, {Costume}, {In Keeping}, {Num Students}, {3mins}, {Disciplines}, {Rules}, {Tap}="yes", {Status}="Yes"), "Yes", "")

Jim - The Monday Man
Watch Our Latest Video: Get Rid of Subitems

3

That’s great thanks you very much for taking the time.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.