Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Importing MS Project plans - tasks in wrong order
Hi, I'm new to Smartsheet and just tried to import an MS Project plan. When viewing it I see that some of the tasks are not ordered correctly from the original plan, anyone else experience this or is this a known problem? Thanks Gary
WBS
I imported a project from MS Project with WBS. How can I maintain the WBS numbering when adding/deleting tasks?
Filters
Is it possible to add a field in the Filter to sort a to z. I would like to sort open items and by what is the nearest due date. Right now it's a 2 step process. Thanks.
Viewing webforms on mobile device
I have multiple webforms but they are not listed under the Webforms heading when I open my smartsheet app on my mobile device.
Is it possible to remove slashes in date and convert to number
a bit like this https://www.mrexcel.com/forum/excel-questions/523890-how-remove-slashes-date-convert-number.html
Smartsheet and HIPAA
Hi Community ... Sharing a bit about HIPAA from the team who helped implement Smartsheet's HIPAA guidelines. Here's the very short synopsis: Smartsheet does not collect or store PHI as part of normal business operations; however, any HIPAA-subject organization with an Enterprise plan that works with PHI can enter into a…
Formula: Remaining Work based on Any given Date
Does anyone have a formula that will calculate the following: Reaming = 194 Deadline = Sept 29 X = How many do i need to complete per day in order to make the deadline. Note: X should change based on today's date Thanks
Identifying children for a specific parent automatically
Hello Community Team, I'm working on automating a % Effort column for my project plan. I need to avg the % effort at the parent level of its associated children. I want to do this automatically without having to identify the children under the parent. I can use =avg(children()) but I will need to specify the children cells…
Activity weightage in %
Hi, I want to know whether smartsheet has facility to show activity weightage in %. For ex. I have one main task and 4 sub task. I want provision to assign weghtage to each subtask. Same should be rolled back to main task. Share the information if available. sandip
Embed hierarchy function as the range within the COLLECTION function
I amy trying to execute the following function. Does anyone know if it, or something like it, is possible: = AVG(COLLECT(CHILDREN(), CHILDREN(), ISNUMBER()))