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 Admin

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

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

At Risk Flag
Hello All, I'm trying to enable an at risk flag with the following criteria: Within 3 days of date to follow up if the status is either "open" or "deferred" ignoring any rows that have blanks for dates I've been searching the forum, I found one that worked, but flagged every empty row at risk because there were zero…
How do I sum cell values in a column up to a specific sum, and return the adjacent cell value?
First time posting a question, fairly new to smartsheet. I have a spreadsheet in googlesheets that does what I need, but as we are moving over to smartsheet with a lot of our other work, I would like to get this set up in smartsheet as well. We grow sweet corn, I have data that I use to make planting schedules and predict…
If, Then with a date and N/A
Hello, I'm attempting to put 3-4 arguments together. I can get 3 to work, but not the 4th. I have 3 columns: Letter Due, Letter Sent, and Sent in Window. The Yes, No, N/A are calculated for Sent in Window using the below formula =IF(AND(ISDATE([*Confirmation Letter Due*]@row), ISDATE([*Confirmation Letter Sent*]@row),…