Is there a way to "cap" the days on a sheet?

Options

I've built a sheet that calculates the days since last event. I display this on a dashboard in chart form. However, I don't want the days to just keep increasing indefinitely. Is there a formula or a way to "cap" the days, for example ">365".

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!