Best Of
Re: Ability to Change Column Type When Conditional Formatting Exists
Another part of this feature would be to allow columns to be deleted when conditional formatting exists. The column should automatically be removed from the conditional formatting rule.
Re: Option to Not Include Sheet Link on Notifications
We send a document to all new users for their future use. It is very confusing for them to get the link to the sheet that they can't access, in much larger text than the link to the document. Please allow another option in automations to include a message and an attachment without a sheet link.
Re: Row automation - add to top of sheet
No progress on this in 2 years? New to the game here and I seem to keep hitting the same hurdles that you folks have already hit years ago that have gone unaddressed/ unresolved.
Re: How to copy a parent row without all sub-tasks (children) to a roll-up sheet?
Hi @Porzel Hans,
In each Project sheet, you should create a new "Level" column to determine the level of rows, with formula: =COUNT(ANCESTORS())
In the roll-up sheet, you can create a "move row" workflow to remove all rows that have level 1
Hope that helps
Re: Multiple Owners to add users to Smartsheet Groups
Fully agree, especially in large enterprises with large groups this role needs to be shared between multiple group admins. This way the sys admins get some relief from doing this too.
Re: Copy Rows Automation: only copy select columns?
I am also frustrated with Smartsheet company, many features that users are requesting to improve but the answer is always coming. NATO - No action, talk only.
Re: Drop down list from another sheet
Is Data Shuttle a paid app? I don't see why it would be necessary to deploy an extra app to populate from a sheet within Smartsheet - I understand the extra app to populate from other sources, but from a sheet within the same Smartsheet account?!? That seems like a major flaw.
Re: Get the file name from a file path.
Give this a try…
=MID([Column Name]@row, FIND("~", SUBSTITUTE([Column Name]@row, "/", "~", LEN([Column Name]@row) - LEN(SUBSTITUTE([Column Name]@row, "/", "")))) + 1, LEN([Column Name]@row) - (FIND("~", SUBSTITUTE([Column Name]@row, "/", "~", LEN([Column Name]@row) - LEN(SUBSTITUTE([Column Name]@row, "/", ""))))))
Enable End Date editing in edit panel of Timeline View
Add the ability to alter the End Date of a task in the edit panel within the new Timeline View. Currently, we see the message, "Formula fields can't be edited in this panel" for our end date. However, in our course, the End Date isn't a formula field.
Below is a screen cap from the timeline panel. (we call our end dates, "need by").
Thanks,
Marc
Completed Checkboxes Only Show in Chrome when Hovering (just started a week ago)
When I view my sheets in Chrome, for about the past week, any completed checkboxes only show up when I hover over them. I checked and this is not the case when using the Smartsheet desktop app. Any reasons why this might be happening? Most of the people who access our sheets do not have a Smartsheet paid license so they likely won't have the desktop app and I think it's confusing.
I've added screen shots in Chrome and then in the desktop app of the exact same sheets. Rows 5, 6, and 7 are checked and in Chrome the only reason that you can see the checkmark is because I am hovering over the cell.
and in the desktop app: