Counting Number of columns with a value

Donna Rowett

Donna Rowett ✭✭

05/11/21 in Formulas and Functions

I am building a sheet that is a high level resource tracker

individuals, by squad.

I have a column for each month.

I want to be able to add up the number of months that have been worked by each individual and then * that by their monthly rate

0 ·

Answers

Donna Rowett ✭✭

05/11/21

Don't Worry......I figured it out :0)

0 · Share on Facebook Share on Twitter

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

Help with writing a formula to show Completed and Past Due along with other status.
Hi there, I am able to get all the status to show correctly, except the 'Complete' and 'Past Due', I know its something simple and I am just not thinking of it, help is appreciated! I am using a 'End Date' and '% Complete' Formula used on the 3rd date down =IF(OR([% Complete]@row = 0, ISBLANK([% Complete]@row)), "Not…
FORMULATE FOR DAYS
I want a formula that will capture network days between dates but that will count only if cell has a date entered. DEPT DATE-1 DEPT DATE-2 RETURN DATE TOTAL TRAVEL DAYS 5/10/2025 5/20/2025 5/30/2025 7 5/10/2025 5/30/2025 The formula should into the TOTAL TRAVEL DAYS Column and will count days based on following scenarios:…
Sumif, index/match and iferror help
I am attempting a formula to sum specific cells from a column from a reference sheet if the Shift column from the origin sheet = 1st and the dates match on both sheets and a return result of 0 if there is not a match, but I'm not getting the arguments correct. #INCORRECT ARGUMENT SET I've tried this as well. #UNPARSEABLE…