how to work IFERROR THE EXCEL DEPOSIT DATA FORMULAS

habtamu sisay 54321

habtamu sisay 54321 ✭✭

01/25/22 edited 01/26/22 in Formulas and Functions

how to work IFERROR THE EXCEL DEPOSIT DATA FORMULAS

0 ·

Answers

Genevieve P. Employee

01/26/22

Hi @habtamu sisay 54321
Would you be able to explain your scenario a little further?
You can use IFERROR around a formula to present something else instead of an error. For example:
=IFERROR(Formula, "Alternate Text")
See: IFERROR Function
Cheers,
Genevieve

Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
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

Weighted Check box's
Just looking to see if there a is a better way to do this. i know i can Write a LONG IF statement to do this. i would like if Step 1 is Check Step Percent would %20 If Step 1 and Step 2 is Checked it would = 75 % if Step 1,2,3 are Checked it would = 95% if step 1,2,3,4 are Checked it would = 100% just looking to see if…
Help with "INDEX MATCH"
Hello, I'm kind of new to Smartsheet and I've been tasked with transitioning a lot of data into Smartsheets, with that said - I have a data sheet that I need to INDEX MATCH actuals into a forecast sheet. Whenever I try to enter an INDEX MATCH formula, it keeps saying that multiple criteria is not supported or the MATCH…
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…