average(children()) not working when cell in child row is a calculated field

Narasimhamurthy Prahaladarao

Narasimhamurthy Prahaladarao ✭✭✭

09/23/20 in Formulas and Functions

Hi,

=Avg(Children()) not working when cell in child row is a calculated field as shown above. Is there anyway to fix this.

Tags:

Formulas

0 ·

Answers

Narasimhamurthy Prahaladarao ✭✭✭

09/23/20

got answer. removed " " in if formula.

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

Is there a FORM ID?
I have multiple forms that can be used to submit data to a worksheet, and I'm wondering if there is a FORM ID that could be used in a column so I know which form was submitted. If yes, is there a specific formula I can use in a column to identify the Form ID and Name of the form?
Index/Match Formula Behavior
Hello, I'm encountering an issue with the INDEX/MATCH function. When the value in the cell being match does not find a match and is recognized as text rather than a number, the formula does not return 'no match' as expected. Instead, it displays the last entry in the reference range. Formula in cell Category Index/Match…
"Boolean Expected" Error
Hello All, I spent a few hours building an equation (I am not an expert) within a sheet that reads another main sheet. =IFERROR(INDEX(COLLECT({GenFertCalc}, {Client Name}, [Client Name]@row, {Tones}, "Granular Fertilizer (Tone)"), 1), 0) The error message "Boolean Expected" occurs in the correct cells, but instead of…