How to subtract the 6month before end date

Options

Aaron Jan

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 ·

Best Answer

Gillian C ✭✭✭✭

04/08/24 Answer ✓
Options
Hi @Aaron Jan
Could you use the date automation so that it triggers 180 days prior to the end date?

1 · Share on Facebook Share on Twitter

Answers

Gillian C ✭✭✭✭

04/08/24 Answer ✓
Options
Hi @Aaron Jan
Could you use the date automation so that it triggers 180 days prior to the end date?

1 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that pops up when I try to convert it to a column formula: I like the current formula because it allows me to set up my Request…
Formula issue
I am using the following formula and getting an #UNPARSEABLE message. I have 3 field conditions that I want to check and set the box to "B" otherwise "S". I Task complete is a checkbox. =IF(AND([Status] = "Closed", [Change Type] = "BOM Cleanup", [Task Completed] = 1), B, S)
Clarification regarding Average(collect)?
I'm trying to calculate the average lifespan for a specific machine in a specific area, but am running into an issue with my average(collect) formula. Here's the formula I have right now, and it only returns as unparseable. =AVERAGE(COLLECT({Lifespan},{Machine},"1",{Row},"1",{Position},"1")) In this instance, its to…