-
Dynamic Allocation % / Resource Management
Monitoring RM (Resource Management) is pointless if the data is inaccurate! Current “Allocation %” is static (if RM is enabled) making RM data inaccurate! Please LIKE or bump if you agree that we deserve a truly SmartSheet w dynamic content! “Allocation %” should be able to accept a formula. Currently when you turn on RM…
-
Kanban: Delete Columns / Edit Column Values
Can you delete some of the default fields in a Kanban if you are hoping to use it in a nontraditional way (e.g. assigned, size, etc.) Addendum: not finding how to delete any fields actually, even those manually created. Addendum #2: not finding any way to update column values after they've been created. I'm striking out!
-
Freeze top two rows
Is there a way to freeze the top 2 rows of a SmartSheet? I have data in the 2nd and 3rd row that corresponds to the header and I'd like to maintain visibility but have yet to find a way. Thanks!
-
create a location updated index from 1-10
I need to create a count of 1-10 that always stays at the top of the column in the correct order even when the sheet is sorted and when web forms are used to input information to the top of the sheet. Sounds simple but I have no clue how to do this without drawing a circular reference and without the ability to reference a…
-
Automated send format question
Good morning, I'm setting up an automated weekly send for a report. I need send it in the vertical format, as though you are sending a row. As it is, it sends in a PDF which is a linear format, and not user friendly for our purposes. Is it either a: Possible to send a vertical format on an automated/recurring basis or b:…
-
Show who modified the value in a specified column
Background We create and approve purchase orders via Smartsheet. On receipt of the invoice to the accounts team the named approver (Contact List column) for the PO is sent an update request with the attached invoice and the field "invoice approved". They review and check the box, submitting the update. There are 12 invoice…
-
WBS or PBS in Smartsheet
Has there been any further discussion on implementing this? If I create the hierarchy in a sheet, when i switch to card view, it is not giving me the view of all the "cards" that report to each parent; rather it is sorting by status or assigned to. Any suggestions on how I can work around the system and implement something…
-
Column Copying
Hi, I have a need to add columns to all of my active project Smartsheets and then I need to create a webform on each of these sheets. Based on other posts I've seen, I cannot copy these columns from one Smartsheet to another so I need to manually add them, correct? Also, there is no way I can copy a webform from one sheet…
-
Enhancement Request: Show and allow edit of Working Days when Dependencies are disabled
When working days are set (either by SysAdmin for new sheets or directly in the sheet) and Dependencies are disabled, the dialog implies they do not impact the sheet. But they do. I posted about this today: http://ronin-global.com/2017/06/23/smartsheet-using-working-days-without-dependencies/ Since they impact the sheet,…
-
Enhancement Request: Provide Highlight for differences using Data Validation
When setting data validation on a column (ie Dropdown type), a warning is provided to warn user there are differences. As an Admin, user can allow these. Provide some means to flag these differences. Moving to a validated column with 25 choices there may be dozens on typos or more in the old data. An easy way to find them…