-
Glitches / Mixed up rows
There have been a handful of occasions now where we load Smartsheet and it looks nothing like it should. Rows get mixed up with no pattern to discern why. Luckily, I had someone take screen shots of what it looked liked before so we could straighten it out. But I need answers. Smartsheet is a great product, and so forth,…
-
Can information be pushed into a SmartSheet from an email message
Hi there, I am curious to find out if I can embed a button (or link) into an email that would make an entry into a SmartSheet. Let's say I want to send an email which asks the recipient to choose one of two options. I could send them to a SmartSheet form and have them fill it out, but what I would rather do is have them…
-
import and consolidate daily changed excel file with SS sheet
Hi, currently my team (4 members) uses one excel file to save information about insurance incidents (task tracking with regularly action documentation f.e. what have craftsmen done, has insurance paid a.s.o). It takes a few month until we all may use SmartSheet. Until that time I would like to daily or weekly import the…
-
Remove name from contact list
I've created a contact list in which I've entered a few names. When I open the 'Edit Column Properties', I see only the names I want in the 'Values' box. Yet when I try using the list to populate a cell, the list that opens includes my own name along with those I entered in the Values box. Because I can't see my name in…
-
Column based alert?
I have a workflow where I need to add a different site every couple days, as we confirm site visit. I want to send alert to the team ( about 40 people) to update and provide their availability to go to these sites. I only know of Alerts being row based in Smartsheet. Is there a way better way to approach this work flow?…
-
Conditional formatting not working for formulas with reference to another sheet
Hello I have an IF-formula in a cell which references values from another sheet. For examle IF(CELL_X from ANOTHER_SHEET = 10, "Ok", "Not OK"). I also have conditional formatting based on the values "Ok" and "Not Ok". However, the conditional formatting does not work reliable. Sometimes the cell is just unformatted. The…
-
Card View by Contact List column type
Hi there, I have a sheet for tracking contracts and assign the contracts to my staff of 10. I would like to be able to have my swim lanes be organized/sorted by the "Contact List" column type (I have my assigned staff in this column). based on this help…
-
Teams Integration
Hi All, I have been tasked by my manager to incorporate SmartSheet into Teams. We have completed the integration and I can now see the shared sheets in Teams without issue. We would like to go a step further and be able to receive notifications in Teams when certain fields are completed on the Sheet. Is this possible?…
-
Multiple approvers on one row
Hello, I am trying to setup an approval that would have 4 contacts that need to sign-off. They are all from different departments, so they would be looking for different things in the approval. I would need all of the approvers to sign-off before the task status changes from "Ready for Approval" to "Complete". Is there a…
-
Gantt chart representation on Dashboards
I know how to make a report so that I can show a timeline in a dashboard. The strange thing is that the Gantt chart does not show dependencies or % complete, even if I include those columns. Is this something that should work currently or something that has not yet been implmented? Also, "Dashboards" does not appear to be…