So i have to variables that i cant seem to work together to hide it correctly
[Is the Student Under the age of 18?] = TRUE, AND(ISBLANK([Custodial Agreement File Attachment]) = TRUE)
This seems to only account for the first one and always shows it if true. But I wanโt to hide it if another field is also True in the same field. But i cant seem to figure out what im missing can anyone help?
So I tried This hides it completely but not what i want. Is what i need is if student = true Show and then separately Hide it if its TRUE
AND(ISBLANK([Custodial Agreement File Attachment]) = โTRUEโ, ([Is the Student Under the age of 18?] = โTRUEโ)) : TRUE
I donโt understand this.
This doesnโt clarify anything.
Just to be clear student = true to show 2 seperate fields [File] and [Image] then If you fill ether out it hides the other.
Hmm Ok so I have 2 columns Iโll call them [File] and [Image] With a show tag of
[Is the Student Under the age of 18?]=TRUE
This will cause both columns to show. However Iโm trying to also attach a secondary value
ISBLANK([Image]) = TRUE
ISBLANK([File]) = TRUE
These work separately. So iโm trying to combine them in a way so that [Is the Student Under the age of 18?]=TRUE shows both of them. But when [Image] or [File] has info it hides the other.
Try theseโฆ
Show_If expression for the File column:
AND(
[Is the Student Under the age of 18?],
ISBLANK([Image])
)
Show_If expression for the Image column:
AND(
[Is the Student Under the age of 18?],
ISBLANK([File])
)
Note that you donโt need to compare a column of type Yes/No to TRUE
or FALSE
to see if it is already that value.
This dosnt work at allโฆ Broken expression. However it got me in the right direction!
AND(
[Is the Student Under the age of 18?]=TRUE,
ISBLANK([File])
)
Thanks for the help!
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |