SUM formula does not provide a total of IF statement outputs

Phil Smith

Hi

I have a timesheet tracker setup with a web form (mobile) to allow me to quickly keep track of my daily activities etc.

 

There is a basic formula setup to auto populate my mileage based on a site code that I enter.

 

=IF(LOC8 = "Home", "00", IF(LOC8 = "KH", "90", IF(LOC8 = "NP", "110", IF(LOC8 = "BP", "110", "xx"))))

 

I'm then totalling up my mileage but keep getting a zero in the total column.

 

I'm guessing that I might need an ISNUMBER statement adding to my total (SUM) formula?

 

Can anyone help please?

 

Kind regards

 

Phil

 

Atus Bartal

Phil, 

Just delete the quotation marks before and after numbers and it will work (totalling). In this (your) case they are in text format and you cannot make calculations with them.

Yesterday there was a very similar issue in the following discussion: https://community.smartsheet.com/discussion/counting-checkboxes-all-parent-rows-sheet

 

I hope that helps

 

Atus 

Phil Smith

Perfect - thanks Atus.