Help with formula - calculate date but only if certain condition met

Topic Labels: Formulas
313 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi All, hoping someone can help with this.

I have a database of clients for content creation, and there are various deadlines for each piece of content we write (for example publish due date, writer instructions due date, draft due date, etc.) We manually enter a publish due date and all other due dates are calculated based on that date using these formulas: DATEADD({Publish due},-10,'days') or DATEADD({Publish due},-5,'days') etc.

Recently we've taken on a number of clients from new marketing sources who will have custom deadlines. We have added a column which specifies where the client came from. I'd like to have the dates calculated as above, but ONLY if the client came from Source A.  If the client came from any other source, the field should be left as a blank date field so we can manually enter dates. 

Is this possible, and if so what would it look like?

Added example:

So IF client source = sourceA, then DATEADD({Publish due},-10,'days')
but if the source does not equal sourceA, I want to add a custom date.

0 Replies 0