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

Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list