Adding two columns together for a total sum

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 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
Netdays calculation with optionnal date column
Hi i'm looking for a formula to calculate the netdays between 2 dates. but i have 3 dates in the equation. a date column (date 1) whit references from another sheet and a manual one (date 2) to overwrite the first one. the third date is the "today" date (date 3). so i'm looking for something like: netdays between date 1…
Formula to count in progress child tasks using % complete
Hello, I am trying to obtain the count for in progress tasks using my % complete column and excluding parent rows. The criteria I want to use: Count if Children = 0 (no parent rows) If % complete <1 and >0 I have the formula working for one value: if % complete <1. But I'm stuck on trying to get the formula to work with…

Adding two columns together for a total sum

Help Article Resources

Categories