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.
