Cannot create "Net Days" column formula

ktcran

I have a column that auto-populates the number of days left between now and a project launch date.

=NETDAYS(TODAY(), [Effective Date]@row) is the formula that I have in the column, and it works when applied row by row. It will not allow me to make it a column formula. Why not?

bisaacs

Hey @ktcran,

Is the column you're doing the calculation in a Duration type column? Not sure why, but those types of columns don't allow for column formulas, you'd need to have the column type be a Text/Number.

bisaacs

Hey @ktcran,

Is the column you're doing the calculation in a Duration type column? Not sure why, but those types of columns don't allow for column formulas, you'd need to have the column type be a Text/Number.