-
Cross referencing two Sheets
Hi All I am currently using a web form to collect data for a staff onboard systems which is working great, however, I need a way to cross-reference the data coming in from the form to a list of people I am expecting. until the vlookup feature arrive later this year any ideas on how to do this would be greatly appreciated…
-
Highlight Changes with a unique color, shade, or pattern for each user
I would like to submit an enhancement request for the Highlight Changes feature. The tool currently shades cells with a background color if a change has been made in the last seven days. Unfortunately, the same color is used for changes performed by everyone. I'd like to request the ability to customize the background…
-
Organize formulas on a sheet
Hi I have many formulas on a sheet which are linked to another sheet and the result is picked up on a dashboard. On the sheet i have added extra columns to place the labels but these column fields then show on the kanban card view which i don't want. So question is how best to organise formulas on a sheet, is the below…
-
Formula placement where data rows are constantly changing
Hi All, I am trying to build a report or sight that captures the count of various columns based on other columns. {PLEASE add the funciontality of formulas referencing other sheets}. The count and countifs formulas work well in isolation. I can add the formula in a new column and then hide this column. The problem I have…
-
New Notifications to non Smartsheet users
HI Guys, i have just tested this amazing new future of allowing a non smart sheet user to get notifications i was trying to set it up for clients To receive a notification when i updated a new payment into their Receive payment sheet It works amazingly just 1 problem the attachment of the row which in my case is the…
-
New! Row Edit Multi-Pane View - will this help your SmartSheet efficiency?
Hi, why always separately open the multiple edit dialogue boxes for data linked to a row -when you could have one click optionally open all all simultaneously in a Multi-Pane popup window! - Row Edit, Discussions, Sharing, Attachments, (PLUS even a new feature - part of the multi-pane window showing an email thread linked…
-
Due Date won't edit
Hi everyone Once I type in a date in my Due Date column, it won't let me change that date. Every time I edit it, it changes back. If I delete the field, it will become blank, but as soon as I try to type another value in, it reverts back to whatever the first date I entered was. Can anyone help? Thanks! Harry
-
WOULD LOVE THIS FEATURE
For our use, it would be of great assistance if when you are within a workspace, which is housing, say 50 sheets, you could check all and using the actions button duplicate all sheets. I could then move those sheets to a different folder while keeping the data needed and deleting what isn't. We tried templates but our…
-
Can I remove the 'login' link when sending a row by email
We are using a smartsheet to create and sending accommodation quotations. If I send a row of data by email, the recipient gets a nice view of the data in a vertical format, but sees a 'login' link at the top of the email. This is confusing for the recipient as they cannot login to the smartsheet account - we do not want to…
-
limitation on visible characters per cell (110 characters)
Hello Smartsheet Community, There seems to be from my tests, a limitation on the number of visible characters per cell. I added about 200+ characters and only 110 are visibile. Even if I expand the cell and activate the "wrap text" function, same results. Is this hardcoded? thank you
