How do I get a formula cell to return to blank when the corresponding cells don't have any values?


I am using the formula below to calculate the number of years between today's date and a persons start date in another column.

=(TODAY() - [Start Date at TDG]1) / 365

If the start date has not been entered, the Years @ Company cell is showing "0". How can I get the cell to show as blank until data is entered in the start date column?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!