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

Help with COUNTIFS with multiple criteria in same range, where to put the OR operator
This is a frequent topic in the smartsheet community, and I think I've read most of the responses, but I can't resolve it for my particular situation. : ( Mostly I get unparseable when I add my OR criterion. This is used on a project portfolio metrics sheet, where I want to count for each particular calendar year how many…
Numbers Only Formula
Hello, I am trying to have the column "Order/Job #" automatically populate the 6 digit number of the parent row in the column "Customer or Task Name". So basically in the screenshot below, in the WHITE row, column "Order/Job #", it would say 661181. Basically, there will be multiple children rows under each parent, and I…
Count if formulas for assigned individuals
I have a work breakdown structure and I am trying to count the number of tasks allocated to contacts in the sheet. The data is spread over multiple columns. I have tried using this formula in a sheet summary - =COUNTIF({Assigned to SME for initial build}, "Joe Bloggs") + COUNTIF({Assigned to: SME 2 (peer review)}, "Joe…