My project contains multiple sheets that need to be summarize. Each sheet has a sheet summary but since my data spans across multiple sheets, I need to combine the calculated fields in my sheet summaries to be combined (sum, average, count etc). I realize I can create a  metric sheet that makes use

Hi all,

We have contact columns that we are trying to add hundreds of contacts too. The number is not above the limit specified by Smartsheet that I found; however, names continuously disappear. For example, User A may be able to drop-down and select John Doe as the main contact, but User B can't

Hi, is there a way to automatically merge rows to a google document when a new row is added?

Example: We track phone monitoring in a sheet and want them to auto-merge into the Google Doc or PDF instead of someone having to do manually.

This one might be fun.

I have a number....let's say   32.1204

But what I really want is to have it be 32.12040  because I want to turn it into a string and peel off the right two numbers.

I've tried ROUND(number,5) but that doesn't work.

I can hit the increase decimal button and make it show as

Here's a tricky one that has me stumped.

I have parent/child arrangement of project task completion.  Calculating total project completion by using a simple AVG(CHILDREN()) does not get me a true completion value for the entire project.

Someone is going to tell me I went to a lot of trouble when I

Is there a way to alter the Column Headers? IE Bold or Sizing or Font? I haven't seen any of these options but I just want to verify that it is truly the

Hello - 

I have published reports to a dashboard that my clients can go and check.  However, I've noticed that, if you're looking at a published, read-only report, you can't export it into any useful format, such as excel.

Is there something i'm missing?

Hi All, 

I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute).

Hello everyone! 

Hoping I can get some assistance from the Gurus around here.

Currently, we have an =IF formula that looks at the Due Date of a project and:

• if the project is today, it returns THIS WEEK
• if the project was last week, it returns LAST WEEK
• if it is next week, it returns NEXT WEEK
• if it

I have my sheets set up where each row represents a project and respective information.  I have a column in each that can be changed to a department heading and I have an automation set up to make it so that when changed the rows move to the department sheet selected in the drop down box.

Now, I