Modifying column formula based on criteria of other columns?

Jackie_H

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!

Kelly Moore

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