I use the gantt charts and calendars to make sure my contractors are not in two places at once.  Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned to them?  I seem to have to do it to each individual task.


Hi I am a new user of smartsheet.  I need help on why this excel formual will not work.  I get 




=IF(([Total Billed]40)<10000,0,

IF(AND(([Total Billed]40)>=10000,([Total Billed]40)<20000),([GP Amount]40*5%,

IF(AND(([Total Billed]40)>=20000,([Total Billed]40)<30000),([GP




I am fairly new to smartsheet and wanted to know if it was possible to automatically add a set list of tasks/ indented rows to a row that had been added via web form?


I review sets of data that are submitted by multiple business unit and partner companies.

The form this takes in always the


I have been testing the SmartSheet calendar sync with a test Google account.  Now I want to change that Google account and use a different one to sync that calendar.  When I turn off calendar syncing in my SmartSheet, and then turn it back on, I'm not prompted to enter the Google account to use, as


Was wondering if its possible to create an online sheet for my clients to be able to get Status updates?

Ideally I would want them to go to an online sheet and put in their Invoice number and it will tell where their job is at (With Designer, Proof Sent, At the printer, Completed etc.)

Does anyone