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

Options

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
Options
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

Sum IF Help With a Formula - I think it is SumIF
Hello all, I have a sheet with a column that has this formula in a column labeled "This Month Available Hrs Remaining" =NETWORKDAYS(TODAY(), IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, DATE(YEAR(TODAY()) + 1, MONTH(TODAY()) - 11, 1) - 1)) * 8 * Count@row This formula lets me know how many man hours I have…
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
Simple Workflow Not Triggering
Hi, I have a very simple workflow set up using "TODAY()" date as a formula. Basically it's a tracker with due dates, and if a particular task is not "Complete" by the due date, the status will change to "Overdue". Let me emphasis that there are no external links on this sheet and the formulas work fine. The workflow is as…