Formula question  isblank, sums?
Trying to figure out how to make this work. I'm terrible with advanced formulas like what I'm trying to accomplish, and have no idea how to make it work.
The extension rate needs to be multiplied by 12, then divided by 13 to give the cost per period (13 periods of four weeks, versus 12 months). Then I would apply/drag this formula down the entire column so they all work the same.
However, not everything is on an extension. perhaps it seems trivial, but I do not want it to output anything in the POP column if there's no value in the extension rate. It would be easier to see if it remained blank.
Answers

Use an =ISBLANK() formula. So for example would be:
=IF(ISBLANK([Extension Rate]@row), "", [Extension Rate]@row * 12/13)
This says that if the extension rate is blank then leave the cell blank but if not then *12/13. Then right click and column formula to convert it into a formula for the whole column.
Hope that answers the question!

I would use this:
=IF([Extension Rate]@row <> "", [Extension Rate]@row*12/13)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!