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.