If (or?) Formula help please

I am not sure how to add in an “or” situation to this formula.
Here is my formula:
IF({Task Start Date},IF({Task Status}=‘Completed’,{Description}&" | “&‘COMPLETE’&” | “&DATETIME_FORMAT({Status Updated},‘MM/DD’),{Description}&” | “&DATETIME_FORMAT({Task Start Date},‘MM/DD’)),{Description}&” |")

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!

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")))

1 Like

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 | " ...
2 Likes

lol, I should have seen that!

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?

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")))

1 Like

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?

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.