
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 29, 2021 06:38 AM
My current formula works. IF({Post Date}<{Today’s Date},‘READY’)
But if {Post Date} is empty it is also saying ‘READY’
What should I add to the formula that ignores a field if it is empty.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 29, 2021 08:21 AM
I think the formatting of the quotation marks may be getting screwed up by the Code formatting on the forum. Try deleting and rewriting all the quotation marks, so they are plain text.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 29, 2021 07:05 AM
One way to do this would be to wrap that IF statement in another IF statement:
IF({Post Date}, IF({Post Date}<{Today’s Date},‘READY’))
You could also simplify this by using TODAY(), which would remove the need for the field {Today’s Date}:
IF({Post Date}, IF({Post Date}<TODAY(),‘READY’))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 29, 2021 07:47 AM
That didn’t work. It gave me this message.
Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 29, 2021 08:21 AM
I think the formatting of the quotation marks may be getting screwed up by the Code formatting on the forum. Try deleting and rewriting all the quotation marks, so they are plain text.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 29, 2021 10:02 AM
It worked. Thanks for your help.
