Return 1st, 2nd, and 3rd non-blank value per row

WorkforceAnalystOSDH

WorkforceAnalystOSDH ✭✭

12/15/23 in Formulas and Functions

I am trying to replicate the following excel formula in smartsheet:

My knowledge of Smartsheet is pretty limited, and everything I have tried so far has given me an error. Any help is appreciated.

0 ·

Answers

Lucas Rayala Community Champion

12/15/23
Hi @WorkforceAnalystOSDH, does this work?
=INDEX(A2:G2, 1, MIN(INDEX((A2:G2<>"") * COLUMN(A2:G2),,)))
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

My formulas on my Metric sheet are calculating 0 and I'm not sure why
Hello, I am trying to create a dashboard with widgets to display our overall progression on multiple projects. I was told a Metric sheet would be best to do this. I am creating my first metric sheet but the formulas are calculating 0 and I'm not sure why. In the first section below I am wanting to add up how many projects…
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…