Can I SUMIF with the vlookup cell data?

KimTDSYN

KimTDSYN ✭✭✭

09/14/23 edited 09/14/23 in Formulas and Functions

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?

0 ·

Answers

Eric Law ✭✭✭✭✭✭

09/14/23

@KimTDSYN SS should be able to, but it is wonky sometimes.

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

Average of Color Symbols (RYG) on same row
I need to be able to create an average (In the Overall Status field) of the 3 filed to the right. As you Can see, they are symbols with the standard stoplight (RYG) colors. I have done this (with the help of the community) for parent/child, but now these fields are on the same row.
I am getting #circularreference and I am not sure how to fix it.
I am trying to get this calculation to work =IF(TODAY() < [Start]@row, "not started", IF(AND(TODAY() >= [Start]@row, TODAY() <= [Finish Date]@row, [% Complete]@row < 100), "In progress - on track", IF(AND(TODAY() > [Finish Date]@row, [% Complete]@row < 100), "in progress - delayed", IF(AND(TODAY() > [Finish Date]@row, [%…
% in formula issue
Good morning, I have a column which named "% Complete". The next column, I wrote: =IF([% Complete]@row = 100, "Complete", "Not Complete") That works if the % complete column is 100. But it doesn't work if I turn the "% Complete" column into a percentage format. How do I tweak my formula to state that if it's "100%", it's…