-
Planned vs actual progress (hope this can help you)
Hello everyone, I'm a little bit new on smartsheet and the first thing that I faced was how to measure the variance of my project, I tried the forum, youtube and help from this page to get what I wanted, it was not what i expected. So to get that visibility I decided to ad a new column (% Planned) that shows the…
-
Not receiving workflow notifications (email or within SS)
I have a user who receives the email and workflow notifications within Smartsheet when someone else updates the sheet, but does not receive them when she updates the sheet. I created a new test sheet and workflow and she received the email and notification. I then had her update the sheet (she was screen-sharing and I…
-
Issue with Filters on Links
Hello, I have a large project sheet where I am trying to create multiple links on our SharePoint site. Each link should show a different filtered view of the Smartsheet grid. I thought this could be done by hitting the Share button, editing the Default View, and then copying the sheet link. The hyperlink changes so I…
-
Unable to pull through the series name to Chart widget
I am trying to make a dashboard widget to chart a report I have of project % completion. I want the series titles to be the project names., but it's throwing "unnamed series' at me and I'm left with un-named dots on the chart, which I can't edit and am really frustrated with. The Project Name and the % complete are in two…
-
Summary report where multi-choice dropdown list is used
Dear Community, I am struggling with creating summary report for one column, where multi choices could be picked. Is it possible to summarize this? I would like to make a nice looking dashboard out of this, but when I click summarize, column where choices are is not present, it is empty.
-
Complete "card view" of a single record
Hi all, I am looking for an option, native to Smartsheet or an integration or an add-in, that will enable me to display a single record in an expanded "card" view that shows more than 10 fields of that record. Is anything like this possible or available? I have a sheet that contains a list of accounts, with the record for…
-
How to auto send an Excel spreadsheet only when sheet changes are made?
We have set up automated workflows for a Smartsheet and its associated sign-up form that we've created. Current state: We have a team who receives an hourly notification from the sign-up form if there are any changes to the form. The email contains a link. What we want: The team prefers to receive an exported Excel…
-
Smartsheet Admin and Adding New Users
Hi all! I am a Smartsheet Admin and was hoping/wondering if there is a capability to automate the addition of a new user through the User Management to then populate a 'employee' sheet/grid? Much like the 'copy/move row' capability. This would help to eliminate the duplicate work of adding the employee through User…
-
Can an IF/CONTAIN formula look to another cell to return a value?
Is there a way for the true portion of of the formula return a value_if_true from another cell. If Column 1 contains a specific text string, it would return the value of Column 2? =IF(CONTAINS("Specific Text", [Column1]:[Column1]), [Column2])) So for example, the formula would be in Column 3 : Column 1 @row has HOUSTON…
-
Link automation between sheets
Hi Everyone! I'm Kaique and I have a question about Automations. We have some smartsheets on our team and we need the automation of a smartsheet to register an event (status checkbox) on another sheet. Does anyone know if this is possible? Thank you very much in advance! Regards from Brazil! Kaique Avelar