Hello I am needing an alternative to a sumproduct funtion.
I have two sheets, one with the raw data (ID, Date and Code) and a separate sheet with ID, Code, and a field for total days. The raw data has multiple dates per ID and code, so I thought it would be a Sumproduct/countif combination, but found that sumproduct is not part of Smartsheets. Is there an alternative that doesn't require a report? Helper columns can be used.
Help Article Resources
Check out the Formula Handbook template!