Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Aug 09, 2022 08:56 AM
I have a two separate Count columns and I’d like to add them together to find the total count. Is this possible?
Aug 09, 2022 09:03 AM
If you’re trying to get the sum for each record individually, that’s
{Count Column 1} + {Count Column 2}
or
SUM({Count Column 1}, {Count Column 2})
If you want the total of all values across all records from both Count Columns, you need to either run a script or link all the records to one common record and use Rollups to do the summing.
Formulas can’t “see” values not attached to the current record, Rollups can’t see values not attached to the current record or linked records.
Aug 15, 2022 11:02 AM
I used your second formula and it was exactly what I needed - thank you!! :slightly_smiling_face: :pray: