Circular Reference / In Excel it works / SOLVED

Oliver Lang
Oliver Lang ✭✭✭
edited 12/09/19 in Formulas and Functions

This has been solved now :) 

Solution is to take the part causing circular reference into a separate row, plus adding another row with a simple IF formula. So we ended up with two more rows, but its functioning and doing what it should. Saves some 30+people now a lot of work. 


Hi there, we are stuck transforming some sheets from excel into Smartsheet. 

The formula below works pretty well in excel, but in our Smartsheet is says "Circular Reference".

We elabortated the expression in Excel ">"&Month()"  might be the issue, but not clear on that. Any ideas how to solve this? 

This this the expression from excel:




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!