SUM formula does not provide a total of IF statement outputs

Phil Smith

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

Find more posts tagged with

Human Resources

Formulas

Comments

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