Help

Re: Formula help

Solved
Jump to Solution
428 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Donna
4 - Data Explorer
4 - Data Explorer

Hi, 

Using the formula below I have an ERROR value issue when there is no date value available for {last deal stage change}. Can anyone advise how I would alter this to just leave a blank space or "no data" where there is no date value available in the date field column?

I need to use the datetime format to tidy up and remove the timestamp 

TRIM({Status symbol} & " | " & {Pipeline} & " | " & "Stage last changed: " & DATETIME_FORMAT({last deal stage change},'DD/MM/YY') & " | " & {Deal Stage})

Thanks!
1 Solution

Accepted Solutions
Ben_Young1
11 - Venus
11 - Venus

Hey @Donna,

Here are two options:

If you want it to just skip it entirely if the field is blank, then you can use this:

TRIM(
    {Status symbol} & " | " & {Pipeline} & " | " & "Stage last changed: " & 
    IF(
        {last deal stage change},
        DATETIME_FORMAT(
            {last deal stage change}, 'DD/MM/YY'
        )
    )
    & " | " & {Deal Stage}
)

If you want it to return "No Data", then you could use this:

TRIM(
    {Status symbol} & " | " & {Pipeline} & " | " & "Stage last changed: " & 
    IF(
        {last deal stage change},
        DATETIME_FORMAT(
            {last deal stage change}, 'DD/MM/YY'
        ),
        "No Data"
    )
    & " | " & {Deal Stage}
)

 

See Solution in Thread

2 Replies 2
Ben_Young1
11 - Venus
11 - Venus

Hey @Donna,

Here are two options:

If you want it to just skip it entirely if the field is blank, then you can use this:

TRIM(
    {Status symbol} & " | " & {Pipeline} & " | " & "Stage last changed: " & 
    IF(
        {last deal stage change},
        DATETIME_FORMAT(
            {last deal stage change}, 'DD/MM/YY'
        )
    )
    & " | " & {Deal Stage}
)

If you want it to return "No Data", then you could use this:

TRIM(
    {Status symbol} & " | " & {Pipeline} & " | " & "Stage last changed: " & 
    IF(
        {last deal stage change},
        DATETIME_FORMAT(
            {last deal stage change}, 'DD/MM/YY'
        ),
        "No Data"
    )
    & " | " & {Deal Stage}
)

 

Thank you @Ben_Young1  all fixed. I really appreciate your help with this!

I'm still finding my way with formulas and nesting 🙂