Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Decimal Point Issue

Options
Scott Lynch
Scott Lynch ✭✭
edited 12/09/19 in Archived 2015 Posts

 

Hi All,

When entering a simple Children Sum which includes a text string to sum numbers in the column below. For example  ="Capex Total: £" + SUM([PO Total]3:[PO Total]113)

 

I'm finding that the numbers after the decimal point either show only one number or lots of numbers depending upon the number of cells the formula has to calculate. Using the increase and decrease decimal buttons has no effect?

 

Using the formula without the text string i.e. SUM([PO Total]3:[PO Total]113) works correctly.

 

Has anyone else found this problem or could it be an issue with my sheet?

 

The screenshot shows only parent rows which are all collapsed.

 

Regards

Children Sum Issue.png

Tags:

Comments

This discussion has been closed.