-
Upvote for Gantt Chart by the Hour
Can I upvote for the Gantt to include feature by the hour? We're coordinating with many subs in every 15 throughout the day and we'd like to be able to track delivery activities by the hour (or every 15 min). In the meantime, we'll be using the calendar feature on Outlook to track these activities.
-
Backlog hours analysis in Smartsheet & Power BI
I need help with a solution to analyze and report on backlog hours by month, based on project tasks maintained in smartsheet. Currently, we have all our project tasks in separate sheets in Smartsheet, with individual rows for each task that include a start date, end date, duration (in days), assigned to, and scheduled…
-
Conditional formatting - specific for me?
As a new user, I need to get one thing clear: Is conditional formatting just seen by my user or is it seen by all users that has the sheet shared to them?
-
Report Builder Not Picking Up All 'Modified By'
Help please!! I have built a report to pull out all data that has changed between a date parameter using the 'modified by' criteria. Prior to my making some changes today, the report was picking up all the individuals that had modified the sheet, however since the changes it is only picking up myself. I am guessing that as…
-
Request Update -- Can you categorize assignees into TO & CC?
Hi - I use the request update feature a lot - but, would love the ability to send the main "request" to the person doing to task and perhaps their manager or teammate as a CC? When I send to multiple people - there is always confusion on who should answer the update. Those CC'ed would see that their are only a copy & not…
-
Webforms | Survey - Customizing Column Headers or Question Content
I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to SmartSheet to alleviate the manual survey creation and lift and shift of data. Problem: Each survey is customized listing a…
-
How to calculate number of days overdue on a task
Hi, I am new to the community. I would like to create a status field that changes color based on number of days overdue. Is there a way to calculate the number of days overdue in smartsheet? Thanks in advance! Susanna
-
Resource Allocation
I would like to create a Team in Smartsheet that is identified as a Resource. Is it possible to create a Resource without assigning an email to the resource?
-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
