Sum(collect)

Robert S Fike

Robert S Fike ✭✭✭✭

05/17/24 edited 05/17/24 in Formulas and Functions

Can anyone see why this is giving a value of 0.

0 ·

Answers

Will Jeffords Overachievers

05/17/24

hi @Robert S Fike, this is a guess that I can test later but you may need to convert your column formula to just a cell formula on Job #Lot Size for the Sum Collect to work properly. Let me know if that is not it and I will investigate further!
Best,
Will

0 · Share on Facebook Share on Twitter
Robert S Fike ✭✭✭✭

06/18/24

Thank you very much

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How to return the last recorded date in a column?
I have a % Complete column and a deadline column. I'm trying to write a formula for when [% Complete]16 equals 100% it returns the last recorded deadline. I'll use this to record the end date of a project. [% Complete]16 is the bolded cell which is averaging the children. The deadline that should return from the formula is…
What am I doing wrong?
Shows #Incorrect Argument set =IF(AND(IF([Jan Scheduling Location]@row = "BPHO|Belen Public Health Office", [Jan Appt Type]@row, "Err1"), IFERROR(INDEX(DISTINCT(COLLECT([BPHO|Belen Public Health Office AT]:[BPHO|Belen Public Health Office AT], [BPHO|Belen Public Health Office AT]:[BPHO|Belen Public Health Office AT],…
Nested IF Statements to Determine Priority
Hi everyone, I've written nested IF statements for a Risk Register, looking at Probability and Impact to determine the color. It's been a while since I've done this and I'm obviously rusty. Can someone tell me why the following is unparseable? =IF(AND([Probability]@row = "High”, [Impact]@row = "High”), “Red”,…