I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions? Thank you!
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. Then the color coding doesnt…
How do I display a week number in a field, that references of a date field.
Hello, I just recently setup some sheets to help with payroll which tracks piece work (we're a manufacturing shop). They input the date they did the work and the number of pieces (I've built a sheet with every single part on it and put their respective price per part that calculates the total for that part). There is also…
Thank you Smartsheet for the new feature allowing Gantt & Calendar Views on Reports! Best thing since sliced bread and dental floss!
Smartsheet’s newest improvements give you more power to choose the level of detail you want to share, both within and outside your organization. Send a project rollup to executives using Reports, now complete with Gantt and Calendar Views, or share a single row to an external collaborator for a quick status update with…
Is there a template out ther somewhere to take all projects shared to an individual and create a weekly report (timecard) showing the number of hours that indiviual is scheduled to work on each project? It seems like most of this is available in Resource manager but I'd like to have it report hours versus % allocation.
I'm trying to create a report where i only see records with End Date = this week. (so not 'the coming 7 days' or something, only this week#) I have column 'Week# that shows the week# of the field 'End Date' in my sheet =ROUND((([End Date]1 - DATE(2015, 1, 1)) / 7) + 0.49, 0) in my report I defined in the 'What' part:…
Hi All, I'm interested if anyone has found a good way to use sheets or reports to count fields meeting a given criteria from another sheet. In my particular case I have one sheet that lists (and links to) project sheets. I would like to have another sheet/report that counts how many projects are green/have a particular…
Is it possible to add more sorting options. right now we only have three drop down bars, I need four. How can I add more?