Trying to get this formula to work but kind of new to Smartsheet.
=sumifs(metres:metres, completed date:completed date, @cell<required date@cell)
I don't know I should be using a flag column, there's already a fair bit of data knocking around and I would rather just get this to work for the sheet summary field.
Essentially, I need an overall metre sum of everything that hasn't been completed by the required date.
Am I missing something?