Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Creating a Formula to Sum Multiple Numerical Fields

·

·

i want to create a formula that adds 5 different fields together, and gives me the total. each of these fields is just a numerical value. what's the best formula for this

Creating a Formula to Sum Multiple Numerical Fields | Clay

12 comments

· Sorted by Oldest

Loading comments

Aaron
·
·
why are some of my fields a grey 0, when the other fields that this references in the formula have a value?
Aaron
·
·
is it required that i re-run a stale enrichment?
Aaron
·
·
a stale cell is preventing my fomrula from working. and i have 1233 stale cells to re-run... which will take thousands of creidts. how do i fix this without using som any credits
Aaron
·
·
i want to speak to someone
Aaron
·
·
here is the table: https://app.clay.com/workspaces/460627/tables/t_0sz7s9g9pwMpgbFCGpT/views/gv_7YcPfc6wNt2w
Aaron
·
·
right now with my filters, i have 1,233 cells that are stale, so they need to be re-run. i originally didn't want to re-run this enrichment because i'm happy with the output, but now the stale cells are affecting my formulas specifically, the cell "Growth/Innovation Awards" is stale, which is making "Scorecard - Awards" stale, which making the formula "TOTAL SCORE" stale
Aaron
·
·
i see. will re-running the cells cost me 0.5 credits each, or 3 credits each? these cells use clay argon
Aaron
·
·
thank you. since i have 1,233 cells to refresh, can you help by crediting back 3700 credits?
Aaron
·
·
i appreciate it. what happened was that i have 6000+ rows in this table, but i started enriching only about 1500 of those rows first based on initial filters (eg. SaaS or not). the outputs it gave me are "company award" after i initial 1500, i started to edit the existing enrichment to better fit the remaining rows, which is why it made the first group stale how would you recommend i do this in the future?
Aaron
·
·
i'll take this into consideration. thank you. so the 3700 credits were added back to the account?
Aaron
·
·
so you're basically suggesting that i use a "testing environment" that is separate from my main production clay table?
Aaron
·
·
thx!