Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hi
I have a column of numbers which are the results of a formula. I then want to add up the column of numbers but when I use a sum formula it just gives me a blank - can anyone assist?
Are you sure the results are numbers? (Are they alligned to the right automatically?) What formula do you use?
Hi - sum in column.....=IF(Emma1 = "A/L", "3.75", "0")
Sum adding up results from column in one cell - =SUM([Emma by Hours]:[Emma by Hours])
The column is formatted as text/ number......
Sara,
3.75 is a number
"3.75" is text.
Try changing your formula to
=IF(Emma1 = "A/L", 3.75, 0)
and see if that helps.
Craig
