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.



  • Kelly Moore
    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!