Sign in to join the conversation:
Has anyone had a problem with vlookup not updating? I had a situation this morning where vlookup was not refreshing the correct value when the search value changed. The way I found to fix it was to re-type the entire formula.
mikepalmer—
If you find this issue happening to you again, please reach out to our Support team directly to troubleshoot further.
I'm having an issue with this sheet: Smartsheet - Quote The COST / PC column is where the issue is happening. On line 4, I'm testing out using a different material that doesn't conform exactly to the sheet's setup but I'm trying to build in functionality to make it possible. When the columns being added by COST / PC are…
I need this formula to sum cells in a reference sheet based on dates. The reference sheet has a column with dates, and there could be multiple of the same date. I was able to get this formula to work on the top line in the screenshot, but the next line is adding the 2 week ending sums together. The planned bushels for week…
I am looking for your help once again :) So the below formula works fine for me however I have other sheets that I also need to reference. I'm assuming I would need to add an AND or OR formula to the below however I'm not sure where or what structure the formula should be. And its to reference another 4 sheets, including…
