-
Column Visibility Restriction or Accessibility
My sheet got 10 columns and is shared to 8 people. 8 of the columns are name of the person I shared the sheet with. Is it possible that person 1 can only view and edit the column assigned to his name? If it is can you teach me how? Thanks!
-
OPPM_One Page Project Manager
I am new to Smartsheet I am a big fan of communicating task and project status via a single page. Does anyone have experience of using Smartsheet using the OPPM format?
-
Remove Parent data automation when Child dates are entered
Hi all, When using date columns, Start/End the Parent row auto-updates with the earliest and latest of its Child rows. Is there any way to turn off this function? Thanks, Josh
-
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