How to Setup A Date Formula Based on a Conditional Statement
I have a date column for noting when someone's contracted employment will end. I'd like to create a formula to reference that date, subtract 180 days from it if their appointment term is "Limited" else the reminder date will be 90 days before the end date. I plan to use this reminder date for a workflow to alert someone.
In my mind, the formula would look something like =IF([Appointment Term]@row = "Limited", [End Date]@row  180, [End Date]@row  90), but it's saying this will not produce a date. How can I write this correctly so that it shows up as a date?
Best Answer

Never mind. This was the correct way to write this. I just had to enter an end date and then convert the formula to a column formula for it to stop telling me I was wrong.
Answers

Never mind. This was the correct way to write this. I just had to enter an end date and then convert the formula to a column formula for it to stop telling me I was wrong.

Hi @Hayden Helms I'm glad you got it to work!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!