The Community Search page is currently unavailable. We are investigating this and hope to have a fix as soon as possible. Please use alternate search engines (e.g. Google) or navigate to your profile to find individual posts. Thank you!
Can I SUMIF with the vlookup cell data?
KimTDSYN
✭✭✭
I have:
File 1: cell 1 is populated with a number via a vlookup formula in that cell
file 2: I want to sumif the data in file 1, cell 1.
Will SS be able to do that calculation? Will it see the numeric value in the cell or will it give an error as it only sees the formula?
Answers
-
@KimTDSYN SS should be able to, but it is wonky sometimes.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
