Adding two columns together for a total sum

NKBDD

NKBDD ✭

07/18/24 in Formulas and Functions

Hello, I want to add a formula to third column (highlighted) that will add "# Dock Doors" and "# Trailer Parking Slips Onsite" together and it to total in the "Total Trailer Locations Onsite"

Tags:

Formulas

0 ·

Answers

Unknown

07/18/24

This content has been removed.

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

Form field controls so data entry is required to sum 100 percent?
We're sending out a survey to understand how much time employees are spending working for each of two departments. We want employees enter time spent as a percentage to add up to 100%. For example an employee might enter 40% for dept "a" and therefore they have to enter 60% for dept "b". Or better yet, whatever they enter…
COUNTIFS formula not working for larger data set
I have a COUNTIFS formula that works when looking at a single column, however when I expand the formula to include a full range of columns (37), I receive an Incorrect Argument Set error. The formula below looks at a column and essentially counts all values as long as it is not blank. It also compares it to a date column…
COUNTIFS Struggle – Need a Hand!
Hi everyone! I'm looking for some help with a COUNTIFS formula. I'm trying to count how many contractors vs. employees we have on a sheet. Counting employees was straightforward since there's only one type. However, there are multiple types of contractors, and I'm not sure how to count all of them together. I've attached…