Count Formula Help

Options

sjohanson

sjohanson ✭✭

05/07/24 in Formulas and Functions

I need a formula that will count the # of times a task is in a specific status. The goal: Formula can tell me 6 tasks are in In Progress.

Example (see screenshots).

Project Plan - Observe AI: Status column

2. Test Sheet: Would I use a countif formula? If so what would the rest look like to calculate?

0 ·

Best Answer

sjohanson ✭✭

05/08/24 Answer ✓
Options
I figured this out, please disregard!

0 · Share on Facebook Share on Twitter

Answers

sjohanson ✭✭

05/08/24 Answer ✓
Options
I figured this out, please disregard!

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

IF Formula Help
Im looking for help with an IF type formula that would return one of the below ratings "Strong, Average, Weak" based on the score in the first column and the indicative range sample in the third column. Im sure its something simple but it's got me stumped at present. Thanks in advance Rob
How do I pull in a value using 2 criteria?
I want to use Project Name and Resource name as a criteria to pull hours worked into a different sheet. Please help.
VLOOKUP and COUNTIFS
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…