ISBLANK help

Shannon Lacerda

Shannon Lacerda ✭✭

05/18/21 in Formulas and Functions

I need help with the ISBLANK! I need the TOTAL cell ( which the formula is in) to be be blank or have a ZERO in if the RFR cell is blank.

0 ·

Answers

Shannon Lacerda ✭✭

05/18/21

Thanks I ended up fixing it.

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

Countifs formula not returning a value.
Challenge: Countifs formula is not returning a value from a cross sheet. Any help would be so greatly appreciated. Summary: I am trying to pull in counts for a specific month and status for an application. The formula doesn't state any errors but it doesn't return the values. Formula: =COUNTIFS($Name18, {Status}, [JAN…
Help with a Sheet Summary Formula Error
I have a simple sheet summary formula that keeps returning "Invalid Operation". I am wanting to count the number of instances where the Potential Loss column is over $500. I've tried every variation of "500" I can think of (500.00, $500, "500.00"), but it's still returning an error. Any thoughts on what's wrong with my…
Need to pull values across several sheets and columns into 1 column stacked, not combined.
I am looking to pull values from the Time 1 column of Example 1 sheet and the Time 2 column of the Example 2 sheet into the Time column on my Reference sheet with those values listed, not combined. Below images may help explain what I am looking for: