Looking for a formula to return one of two text options based on a date
Hello,
What formula would I use for this scenario?
If (column name) is before (date), return "text option 1" and if (column name) is after (date), return "text option 2".
Thank you!
Answers
-
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
Thanks for the formula, but it's giving me an Invalid Operation.
This is what I put in
=IF([Current Hire Date*]@row <= 12/01/16, "6 months", "3 months")
I need to be able to update the year each year so there is a five year lookback. If someone has been here for more than five years we are supposed to give them 6 months notice if their contract is being non-renewed and we are to give them 3 months notice if they've been here less than three years. The column "Current Hire Date*" is set up as a Date column and the date format is MM/DD/YY. Not sure what I'm getting wrong. Please note that the asterisk is actually part of the column header name, so, I'm not sure if that may cause an issue with the formula.
-
Hi @Amber Bailey UNM ,
Try using TODAY() in place of the hard date.
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
@hollyconradsmith , thank you but I ended up building a filter to help identify these. The TODAY() won't work because I'm using a fixed date and this could be run at any time.
Thanks for your help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!