Problem with vlookup calculations

mikeb ✭✭
edited 12/09/19 in Formulas and Functions

I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of a calculated field that is based on data in another Smartsheet. Users enter data into a form and submit the data. The data populates in the Smartsheet, but the entire column for the Vlookup calculation for all rows converts to #NOMATCH, and remains that way which is why the workflow is not triggering. Then as soon as someone goes to the actual Smartsheet (not the form), after just a few seconds, all the rows are updated for that Vlookup calculated field. This Smartsheet was working fine until recently. There were no changes to the sheet other than data.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!