-
Concatenate two cells
Hi, I need to concatenate data of two cell into one cell. I just use the formula "=[Cell1] + [Cell2])", which worked fine and gave the result "Cell1Cell2", however I need to have space or underscore between values of two cell like, "Cell1_Cell2" or "Cell1 Cell2". My practical requirement is: I need to concatenate "date"…
-
Hiding Columns with Filters?
If you can filter by row which essentially hides data, then how might one apply these new filters to hide columns also? For example, I manage “reports due” and “proposals due” in one sheet. Report-related rows have 3 unique columns (ideal for Card view) whereas proposal-related rows have 5 unique columns and BOTH share 10…
-
Any way to stop lines from being automatically added?
I'm setting up budget docs for several people, and Smartsheet automatically adds lines to every sheet. Unless the budget owner is paying attention, this will screw up one of the formulas. Is there any way to turn this feature off?
-
Auto format phone number
Good morning, I'd like to have our phone column (text) formatted so that when I input just the numbers (ex 7195555555) it would format the number as (719)555-5555. Help? Blessings, Loann
-
Feature Request: Groups in the Alerts section
I have sheets that are used tracking that have multiple levels of 'subscriptions'. I like the power of user groups, and may want one group to have a subscription to the alerts, but not another group. Unfortunately, the groups function does not work in the notifications/alerts section. It only shows a complete list of ALL…
-
Adding Task Name to Right Side of Bars
I have an existing sheet that used from a template. It was imported from Project. There are currently no task names beside the bars in the Gantt chart. Is there a way to add the task name to show up to the right of the bars in the Gantt view?
-
Request: Formatting and Design of Web Forms
Hi, would be SO handy to have decent formatting options on a web form. i.e. text size, colour, bold, italics centre right margin etc etc etc... I find it hard with black/grey and a few other colours to make things stand out (such as important notes or messages) We look forward to an improved web form
-
Multiple users editing a sheet at the same time
I noticed that Smartsheet allows 2 (and maybe more) people to open a sheet in EDIT mode at the same time. It looses the changes made by one of them based on who hits the SAVE button first. Is there is an option which doesn't allow a sheet to be open in EDIT mode if someone else has already opened it in EDIT mode? Thanks.
-
After linking cells between sheets, text disappears
Hi, I'm linking a cell between two sheets, and as soon as I create the link, the text in my cell disappears. The blue arrow indicating the linkage remains, but my text is gone. Any suggestions? Thank you!
-
Apply text formatting to tasks in card view
I would like to be able to, essentially, apply multiple conditions to rows and be able to see them in card view. Currently, I have a condition that changes the task bar color based on a dropdown column. I'd like to also have the ability to apply a text-related condtion (changing the text color to red if the due date is…
