Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 03, 2023 11:32 AM
Hi!
Right now I get an #ERROR in Column A when the date is blank. However, I'd like it to return "N/A" instead.
The formula below still results in an error. What do you suggest?
IF(
{Formatted Date},
CONCATENATE(
{Formatted Date}," - ",{Event/Release}
), "N/A"
)
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 03, 2023 01:50 PM
Good callout with the date field. Here's what fixed it:
IF(
IF(
{Date},
CONCATENATE(
{Formatted Date}," - ",{Event/Release}
), "N/A"
)
2 Replies 2
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 03, 2023 11:49 AM
The error is possibly coming from the {Formatted Date} field that I'm assuming is something like this :
DATETIME_FORMAT({your date name},"YYYY-MM-DD")
If so change it to :
If so change it to :
IF( {your date name} , DATETIME_FORMAT({your date name},"YYYY-MM-DD"), "")
Reply
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 03, 2023 01:50 PM
Good callout with the date field. Here's what fixed it:
IF(
IF(
{Date},
CONCATENATE(
{Formatted Date}," - ",{Event/Release}
), "N/A"
)