This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi!
Very new to this process and Airtable, so I’m sorry if this is confusing/doesn’t have enough to go on, or uses the incorrect terminology. If anything needs clarification please just ask!
I’m currently trying to build a scheduling base that will u...
I know I’m overlooking something here but I can’t figure out what that is. I’m trying to create a Publishing Status field using nested IF statements.
So far, I’ve only tested the first few statements, but I can’t get anything other than step 1 to sh...
Solved it!
I ended up using this formula:
IF(NOT(Article),‘step 1’,
IF(AND(Article,NOT(Author)),‘step 2’,
IF(AND(Article,Author,NOT({Internal Outline URL})),‘step 3’
)))
Thanks again for your help! I really appreciate it!
Hey Kris!
Thanks for this response - it was very helpful!
For some reason, this formula is only showing steps 1, 2, and 3. But I think combining what you’ve showed me here with AND or NOT statements might work, so I’m going to give that a try.
