How to subtract the 6month before end date

Aaron Jan ✭

04/08/24 edited 04/08/24 in Formulas and Functions

hi everyone.

I've been trying to calculate on how I can get the 6months before end date to set a reminder before the end date comes.

Can anyone help me.

Thanks

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Gillian C Overachievers

  04/08/24 Answer ✓

  Hi @Aaron Jan

  Could you use the date automation so that it triggers 180 days prior to the end date?

  

  
  

  1 · Share on FacebookShare on Twitter

Answers

• 

  Gillian C Overachievers

  04/08/24 Answer ✓

  Hi @Aaron Jan

  Could you use the date automation so that it triggers 180 days prior to the end date?

  

  
  

  1 · 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