-
number of days between one state and another (not including weekends)
I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| Name | Status | DAYS WITH THAT STATUS 03/03/2018 | cristian | busy | 1 02/27/2018 |…
-
Satisfy all requirements; with different formats of columns
Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete .. initially i think i need to use a countifs formula to tally all columns…
-
How do I get an email notification when someone makes a comment?
Hi everyone I'm perplexed that the comment feature doesn't allow you to notify specific collaborators when commenting on a row. How does one know when a comment was made and specifically if directed @ them? Anyone have any suggestions how to make this work?
-
Integrating Smartsheet and Comments in Google Docs & Google Sheets
There is a great, simple comment thread feature in Google Docs and Google Sheets that I am finding very useful working with teams. You can also do notification with a plus sign and someone's email address (+jane@abc.com) as well as task assignment to one of the people whose email address you have added to the comment…
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
G-Suite reply in comments
I successfully have my emails in Gmail landing in the comments in a particular or new line in a sheet, works great and very helpful. I see in the added email in comments a "add reply" blank. Does this reply just stay with the comment or does it go back out to an email Maybe this is a wish list type of thing, but if a…
-
Issue with comments in Community
Hi Guys, This is an issue not with SmartSheet but with this forum. I have tried Chrome, Opera, Firefox and Edge on Windows and Chrome and Firefox on Linux and get exactly the same behaviour: The issue affects just content in the Comments section of posts in the Community. When I am not logged in to the Community and open…
-
Skype for Business - having issues with joining people in conversations
Skype for business has all been set up for us and I can see who is online, however when I try to open up a chat withsomeone it always shows the message, once I have typed in that they cannot join the conversation and they disappear in the window. Is this normal? Is this a Smartsheet thing or an IT department kind of thing?
-
Trigger notification/update request based on time elapsed since last comment or action on a row
We're using a ticketing system and trying to find a way to trigger automatic update requests when a ticket/row has been unacknowledged for more than 12 hours. Currently we're using the comments feature to post updates to the ticket across shift changes. How can I set an alert to go out if there has been no comment on a row…
-
Comments input area is 'hidden'
When I open the comments dialog, the area to input text is hidden. It has been this way for a few days now. What can I do to fix this?
