Mikey✭✭✭✭

I'd like to add my vote for this feature as well

Add my vote for this - I'm not too fussed about being able to write formula into dependency columns, I'd prefer it if the symbols that are designed to indicate progress (like the 0%, 25%, 50%, 75%, 100% 'Progress Pie' indicator) had the capability to be directly linked to % complete. Am I the only one that thinks it's a…

Hi All, How'd you get on Chris? We are also thinking of using SmartSheet as a stand-alone CRM tool. Does anybody who's had some experience with this like to share some hints and tips?

OK, Got it! Thank you so much Andree

Many thanks Andree, but I can't see that information - where exactly do I right click?

Great news - thanks guys

Not sure if its a total fix, but I made some adjustments to the gantt chart time-frame in the source report and it corrected for me in the dashboard. (right click on timeline, project settings, timeline display) Hope this helps? Mike

Many thanks Charles - I found a work-around from another thread where you set up a new column containing your formula, link the results into another sheet and then link them back into the %complete column. Works ok, but really?! Thanks again, Mike

Hi All, I'm trying to write a formula in the % complete column. I want to use the 'progress pie' symbols - i.e. if circle is empty, % complete should be 0%, if circle is a quarter full, % complete should be 25%, if circle is half full, % complete should be 50% and so on. Is this possible, or does the % complete column not…

I can't help you with the method, but can I offer some thoughts? When rolling up status (which isn't a great plan anyway), I always use the worse indicator rather than average. e.g. if your project has 1 red indicator, it overrides 999 greens or yellows and I'd be reporting the overall status as red because you have an…