Because I don't know the syntax for google sheets - I would like to add a rule that states:

If the date in col D is today's date or earlier, then col B should populate with the word: Published

Sample Sheet: https://docs.google.com/spreadsheets/d/1TWa6QkT1bBc4DxGcNzr5VP4lYsb5m_Zfz3XKI8U4lPs/edit?usp=sharing

IF there are any google sheets users who create custom rules - please advise. TIA.

CodePudding user response：

I've added a new sheet ("Erik Help") with this formula:

=ArrayFormula(IF(D:D="",,IF(D:D<=TODAY(), "Published", "Scheduled")))

Seems to be what you needed in the end.