# If (or?) Formula help please

Topic Labels: Formulas
1281 6
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

I am not sure how to add in an “or” situation to this formula.
Here is my formula:

This only works if my Task Start Date is completed, but I need the Description to show regardless of the date column being filled.
Does this need an if/or statement?

Thanks!

6 Replies 6
16 - Uranus

If `{Description}` is supposed to always be present, you could take out of the `IF()` statement. Try a simplified formula like this one:

`{Description} & IF({Task Status}="Completed", " | " & "COMPLETE" & " | " & DATETIME_FORMAT({Status Updated},"MM/DD"), IF({Task Start Date}, " | " & DATETIME_FORMAT({Task Start Date},"MM/DD")))`

18 - Pluto

The middle of the formula could be simplified a hair further. There’s no need to concatenate several literal strings…

``````... " | " & "COMPLETE" & " | " ...
``````

Merge them into a single string:

``````... " | COMPLETE | " ...
``````
16 - Uranus

lol, I should have seen that!

5 - Automation Enthusiast

Thank you for your help. Unfortunately, the simplified formula is not working either and just gives an #ERROR!.
Don’t I need an “or” statement?

16 - Uranus

If I understand your desired end result correctly, no you don’t need an `OR()` statement. You may be getting an error if your date fields aren’t filled in. So try something like this:

`{Description} & IF(AND({Status Updated}, {Task Status}="Completed"), " | COMPLETE | " & DATETIME_FORMAT({Status Updated},"MM/DD"), IF({Task Start Date}, " | " & DATETIME_FORMAT({Task Start Date},"MM/DD")))`

5 - Automation Enthusiast

I’m thinking it might not be working because the “Task Start Date” is filled when a script template is used. Could that be why the error is happening?