What am I missing here - Adding number to date not working

JGra

Next Due formula

=[Date of Last Check]@row + [Check Interval]@row

Next Due column is set to Date

Check Interval column is set to Duration. I've tried it as Text/Number and Date but I always end up with what you see in the screenshot.

I've googled this and from what I've seen this should work…I think. I imagine its something simple but it's currently eluding me.

EDIT: BONK, Date of Last Check was not a date column. Sorry, I was stuck on stupid.

JGra

annnnnnd it was something simple. Even though I was staring at the screen and I knew the answer I wasn't checking the Date of Last Check column, it was not a date column.

YEESH

…resolved

Jason P

Nice…

Andrée Starå

https://community.smartsheet.com/discussion/128422/what-am-i-missing-here-adding-number-to-date-not-working

Hi,

I hope you're well and safe!

I'm glad you got it working! Easy to miss!

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Please support the Community by marking your comment as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!