Checklist question

[Indira_Chakrava]

Is it possible to create a conditional checklist? I’m doing a literature review and want to keep track of what PDFs I’ve already uploaded. If an article has had its PDF uploaded, I’d like a box to be checked so that I can easily sort out which papers I still have to find and upload and which ones I already have. I’m not sure how to use the ‘IF’ function for this. Any suggestions?
Thanks
IC

[Elias_Gomez_Sai]

You could use the IF + Emoji technique. Anyway, what is your base structure?

Checkbox based on other fields Ask the community

You can’t change a Checkbox field based on other fields. However, you could have a Formula field that outputs a :white_check_mark: emoji if one of the statuses is Approved: IF({Status 1} = "Appoved", " :white_check_mark: ",IF({Status 2} = "Appoved", " :white_check_mark: ",IF({Status 3} = "Appoved", " :white_check_mark: "))) Well, you could do it with Zapier: https://support.airtable.com/hc/en-us/articles/206785897-Using-Zapier-to-integrate-Airtable-with-oth... Anyway, why do you need 3 status fields? Maybe there is a easier way to …

[Indira_Chakrava]

Thanks! That’s what I ended up doing. I’m new to Airtable so I’m still figuring things out. The base structure I’m using is from the ‘Book Catalogue’ template.
I’m trying to make a database for a literature review - so a list of 600-odd articles organized by author, year, journal, language etc. Each article will have to be read and have a form completed for it - trying to figure out how to best do that. Any tips are appreciated!
Thanks!
IC