Not sure how to write formula correctly, not even sure this is a SUMIFS

Hello,

Apologies for yet another basic question, but I'm having troubles wrapping my head around how to get a formula to behave a certain way. I'm still working on a PTO manager tool (requests PTO, automated approvals, and auto calculations on PTO Balance, etc...).

I have 3 total grids (Submission grid, Track grid, and Calculation/Helper grid). The submission grid intakes the data from the form. That data is moved to the track grid, which helps with the VLOOKUP and stores the PTO being requested off. The Calculation/Helper grid does most all the calculations. I've uploaded screenshots of each.

I'm trying to get the formula in the [PTO Taken] column rows to use the value in the [PTO Used] column row, but only if the value in [PTO Used 2] column row is blank. If it is not blank, then the formula should use the [PTO Used] column.

Submission grid.JPG

I'm over my head on this one, I was able to the formula to grab the value from [PTO Used] column row, but not to check both and use only the one I want. I also apologize if this has been covered somewhere else, please feel free to link me.

Thanks for the help,

Tyler

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!