Formula help needed - if/then

crystal.schroeder

Is there a way to make my formula (below) that if the "type of CPG" says "priority" in it that it can be - 21 days and all other types would be - 14 days?

hopefully that makes sense!

Nic Larsen

Try:

=IF(CONTAINS("Priority", [Type of CPG]@row), [Meeting Date]@row - 21, [Meeting Date]@row - 14)

Nic Larsen

Try:

=IF(CONTAINS("Priority", [Type of CPG]@row), [Meeting Date]@row - 21, [Meeting Date]@row - 14)

crystal.schroeder

@Nic Larsen you rock thanks!!!!