We have an a Smartsheet of Events - tradeshows etc that we will be participating in. While initially developed for internal sharing, I have added a "publish" checkmark column, with those items checked…
I am using update requests quite a lot, but they are not for recurrent type activities. I would like to think they would be recieved and acted on, so I don't set up reminders. My problem is that recip…
Hi, I have been asked to put my existing excel spreadsheet gant planning chart into smartsheet gant chart. Not happy as I am a total novice on smartsheet - but it is failry intuitive even for an old b…
Hi: what would be the formula for the following: project light status | Start Date | Proposed finish date | Finish date | Complete G 1/1/2015 2/10/2015 2/10/2015 complete R 15/1/2015 2/10/2015 3/15/20…
Using a project smart sheet with Gantt functionality, I would like to be able to hide competed tasks in the project sheet. It is used for production scheduling so the once a task is completed it is no…
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
I need to create a formula that looks at two different date fields and produces the result as a check (or no check) in a checkbox field. The two columns are: "Date Requested" and "Date Received." The …
So i have been tasked with learning the In's and Out's of smartsheet and to find the best way to utilize all of its tools for our company. we currently do the majority of our work through GP which as …
I am testing SmartSheet in an effort to organize projects in our design and manufacturing company. Many of our projects have tasks that are less than a day in duration. We typically estimate jobs in h…
I have a RYGG, Status and % Complete columns. The RYGG has a nested IF statement that takes its values from the Status cell. I manually enter data in the Status (In Progress, At Risk, ..., Complete) a…