-
WBS numbering and work arounds
Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the sheet for each project/group of projects is first started, its easy - everything is labelled from 1,2,3,4,etc til the last row.…
-
can smartsheet support "comments" and “cell merge”?
Hello, I am wondering whether smartsheet can support "comments" and “cell merge”? -Cell comments: Write a comments for the value in the cell, like excel? - Cell merge: merge the adjacent cells as one cell - Two level columns headers: Ex: Level 1: Jan Level 2: Qty, Amount, Price Now I can only write header as: Jan qty, Jan…
-
Parent level approval requests?
Is there a way to set up approval requests at the parent level? Parent row includes project description, Owner, PMO, etc, etc. Child rows break out task types into groups Grandchildren row list owners of each task under the task type group. Example: Description Owner PMO * Project XXX Jon Doe Pam PMO (Parent row) *…
-
Charts with no data
I have a dashboard that I update weekly to show any applications that were processed through our office. Sometimes, there are weeks where we don't have any applications processed, so I don't have any data for the week. Is there a way to customized the error message in the chart? I've included a screenshot. I just want it…
-
Data accuracy
I am working on a way to verify if data in all my sheets (about 10) is accurate, however, the trouble I am running into is the data is frequently updated. Is there a way to run a report that is like activity log within each sheet? Thanks, Amy
-
Suggestion - Default Attachments Checkboxes to 'unchecked' in Outlook Plugin
Hello Smartsheet, and thank you for such a great tool. One suggestion that would really save me a lot of energy - would/can you default the auto-checking of checkboxes in the list of Attachments in the "Smartsheet for Outlook" plug-in to 'unchecked' please? (or, alternatively, add a link to "uncheck all" at the bottom of…
-
@ notification has a hard time finding email address
I love using the @email-address to send notifications to my team - thanks for adding this feature. We have a large organization and I find that when I begin to type someone's email, Smartsheet presents a huge list of potential emails and it is challenging to find the right one since I do not have these email addresses…
-
How to set Due Date Reminders
How do I set due date reminders for specific tasks (rows) assigned to specific people (assigned to). As a default, I want a reminder to be sent to each assignee on the date that their task is set to begin (or, in the case, of a milestone, on that date). I would also like to set a second reminder on the date their task is…
-
Auto update of "Custom Date Range" when scheduling a report?
I'd like to schedule a report each month to automatically cover the next 90 days. But it looks like I'd have to update the "Custom Date Range" each time for the next 90 days. Is there a way to have the Custom Date Range update automatically? For example, "T " to "T+90"?
-
Smartsheet reporting and dashboard
Hi, Attached below is a screenshot of a Smartsheet dashboard that we have had set up on our project by someone else. The dashboard data is being driven by a report which is in turn being driven by a stats sheet (screenshots also attached below). I have a couple of questions in relation to setting up a different dashboard…