Using linked fields in calculated fields is a big up, but I still find the calculated fields very very limited. I find myself constantly needing to divert back to the API or Excel to make any fields beyond very simple calculations. My biggest concerns are:
-Very Low Character limit on calculated fields, making more complex conditional fields pretty much impossible to do within Shotgrid
-No specified functions, for example NETWORKDAYS would benefit a lot of calculations. The duration fields/values have nearly no use in my case because it counts weekends. (I’ve seen this requested by folks on here, but no current plans on roadmap to address this)
-‘Contains’ condition for text fields. (Ex. If Task Name contains Keyword)
If the calculated fields had half of the functions/capabilities of excel formulas, I’d be able to do a whole lot more and a whole lot faster with Shotgrid. Just wanted to create a discussion on here if anyone else has similar concerns.