Using dates without a date column.


Is there a way to use dates in formulas without them being in a date column?

I am trying to reference a drop-down column that has some dates in it and then take 42 days off of them.

Is there a way to do this without the dates being in a date column as it needs to be a drop-down column.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!