-
Hiding formula links
Is there a way to hide cross sheet formula links? If you define a reference range on a sheet for vlookups I would rather not see all my columns on the parent sheet filled with little mouseover links. Thanks
-
UDF / User defined Fields for SysAdmins
I propose that you add a few extra fields that can be used by SysAdmins when provisioning users. There you could specify budget numbers, country of origin, etc. as needed to administer Smartsheet more easily. Today, we have to capture that data in a request form. Then, export the user list and merge with our form data to…
-
[QUESTION] What (and HOW LONG UNTIL) Enhancement Requests become Features?
Hi, After using Smartsheet for about a year, I have not found where Enhancement Requests become features in Smartsheet. It seems that there is a chasm of disconnect between the Community's expectation for Enhancements becoming Features and that of Smartsheet. So, what's the process to vet out Enhancement Requests and plan…
-
Locking cells in sheet
Hello, I am trying to determine if there is a way to lock the formulas I have placed in my sheet so that the users cannot override them to hard key in numbers. The formulas have been entered into all of the necessary cells but as it stands, users can simply clear them out to enter the amounts in their own way. We have…
-
Harvey Ball Status - Empty is now a blank instead of an empty circle
Hello, I noticed the Empty status of the Harvey ball is now a blank instead of an empty circle. Was there a reason for this change to make this operation less useful? The selections used to be Empty (light grey circle), quarter (1/4 filled), half (1/2 filled), three quarter (3/4 filled) and full (all full). Can we think…
-
Way to use grouping in reports with a multiselect column
Is there a way to group a report using a multiselect column? I have spent a while going thru the community posts going back to when the grouping in reports was released and see that this is something that has been asked about repeatedly with no solution or real work around. We have some sheets that require this…
-
Add filter & sort for unlicensed users
Currently, we don't have the ability for unlicensed users to add their own filters and sort data. This creates a burden for the designer/owner to create every filter for every user. Unlicensed users should be able to manipulate the data in a sheet/report as they desire.
-
@Column Reference
I have a formula that I would love to make into a column formula but am unable to because I reference a cell (a helper cell I have in the first cell of the column that is the same as the column name). Without being able to use [column name]1 in a column formula I am unable to have it be a formula that can be easily copied…
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
Merged: Changing Cell Value based on Cell with a Cross-Sheet Formula
This discussion has been merged.