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

Formula to SUM = 0 Why?
I created a formula to sum the values in other formula columns but the return is "0". I have created other sheets with the same type of formula and the return is correct. How is the return 0 on this formula. It appears to be correct.
Label Status Dot Help
Hey all! I am trying to add the color symbol dots to align with status and I've tried so many formulas, I cannot for the life of me figure this out. Nothing crazy in this sheet, just want to align the status to the color of the dot. If Status = Complete —> Green If Status = In Discovery, In Process, In Review —> Yellow If…
HELP!!! Max Collect for Dates
I utilize Smarthsheet to manage a hospital schedule. I need to find out the last time a staff member worked. I have been playing around with Max Collect and constantly failing… #UNPARSEABLE Things to note: The Primary column shows the name of the staffer multiple times with multiple different dates under the Date Worked…