Modifying column formula based on criteria of other columns?
Hi all,
Is there a way to modify a column formula based on criteria of other columns? For example, if a column is checked, to use a specific date rather than the date listed? My goal is to create a formula that defaults to the 15th of the month IF a certain box is checked YES.
Thanks!
Answers
-
Hey @Jackie_H
Yes - you can designate a date using an IF statement. You cannot, within the same column, have dates selected sometimes by formula and sometimes by manual entry. There are workarounds however, if needed.
=IF([your checkbox column]@row=1, DATE(YEAR(TODAY()), MONTH(TODAY()), 15)
The formula above will insert a date using the current month and current year, and day = 15. Because I didn't know what you wanted to happen if the checkbox was left unchecked, the formula above will leave the date field blank when the checkbox is unchecked. You can convert this formula to a column formula.
Don't forget you must change the checkbox column name to your actual column name
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!