I have a formula I can't seem to create.

Orion086

Orion086 ✭

04/08/22 in Formulas and Functions

I strung 4 columns and would like to look up to see if the text repeats then if it does add 01.

smartsheet formula.png

0 ·

Answers

Emily Zeiger ✭✭✭✭

04/11/22

Not sure what you mean by 'add 01' but here is what I would do.
=if(countif(Column20:column20, =column20@row)>1, "01")

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

Can you help me with a COUNTIFS Formula (Second Criteria)
Trying to count Rows in a sheet that meet 2 criteria. I am not an advanced user, so I am missing something. Can you take a look at this formula and give me some suggestions? =COUNTIFS({Phase-TPN}, "1", [Start SCRA]:[Start SCRA], "Yes")
Can you convert this vlookup to an index match or index collect?
basically, it rest id exists in both SS and on the other SS a field is either checked or unchecked, then result should read Yes. =IFERROR(IF(AND(VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 1, false) <> 0, VLOOKUP([Restaurant ID]@row, {CFA NRO/Remodel Cabling Tracking Range 1}, 39, false), 0),…
Help with Health Formula
When I put this formula: =IF([% Complete]@row = "100%", "Green", IF(AND([% Complete]@row <> "100%", [Due Date]@row >= TODAY()), "Yellow", IF(AND([% Complete]@row <> "100%", [Due Date]@row < TODAY()), "Red", ""))) The status shows Red when the % complete is 100% and the Due date is past. How can I correct that? Thanks