Skip to content

I am receiving a zero "0" in the cell

cswicegood

cswicegood ✭✭✭✭

02/05/25 in Formulas and Functions

I don't know how to ask this question.

I have cell formula below.

When I run the automation, I receive a "0" before the drop-down value in the cell

Any help would be appreciated.

Thanks

Tags:

0 ·

Answers

Leibel S Community Champion

02/05/25

@cswicegood change the beginning of the formula to: ="" +

0 · Share on Facebook Share on Twitter
cswicegood ✭✭✭✭

02/06/25

Thanks!

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

How to return the last recorded date in a column?
I have a % Complete column and a deadline column. I'm trying to write a formula for when [% Complete]16 equals 100% it returns the last recorded deadline. I'll use this to record the end date of a pro…
Answered ✓
Formulas and Functions
11
Apr 24, 2025
4
What am I doing wrong?
Shows #Incorrect Argument set =IF(AND(IF([Jan Scheduling Location]@row = "BPHO|Belen Public Health Office", [Jan Appt Type]@row, "Err1"), IFERROR(INDEX(DISTINCT(COLLECT([BPHO|Belen Public Health Offic…
Answered ✓
Formulas
Formulas and Functions
20
Apr 24, 2025
5
Nested IF Statements to Determine Priority
Hi everyone, I've written nested IF statements for a Risk Register, looking at Probability and Impact to determine the color. It's been a while since I've done this and I'm obviously rusty. Can someon…
Answered ✓
Formulas
Formulas and Functions
22
Apr 24, 2025
5