Circular Reference with Vlookup (Works in Excel)
I have a project management table I was hoping to make in Smartsheet. Basically, if a task has a "Predecessor", I'd like the "Start" for that task to be the end of the Predecessor task (whichever task has a matching "Task ID"). If a task doesn't have a Predecessor, I'd like its Start date to be the End date of whatever in the above row. I was able to do this in Excel, but in Smartsheet I end up with a "Circular Reference" error. I've tried a Helper column and everything else I could think of, so any help would be appreciated!
This is the Excel:
I've tried to use pretty much the same function and end up with this:
Help Article Resources
Check out the Formula Handbook template!