Formula help needed - if/then

crystal.schroeder ✭✭✭✭

11/20/24 in Formulas and Functions

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!

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Nic Larsen ✭✭✭✭✭✭

  11/20/24 Answer ✓

  Try:

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

  2 · Share on FacebookShare on Twitter

Answers

• 

  Nic Larsen ✭✭✭✭✭✭

  11/20/24 Answer ✓

  Try:

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

  2 · Share on FacebookShare on Twitter
• 

  crystal.schroeder ✭✭✭✭

  11/20/24

  @Nic Larsen you rock thanks!!!!

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list