-
Issues automating dashboard that feeds from a sheet with calculations
I am wondering if there is a solution or way around this issue in Smartsheet. I noticed that the reports function in Smartsheet does not allow you to do calculations such as countifs, sumifs, averageifs, etc. It only allows you to make graphs/metrics to report on if the information you are pulling from is number related.…
-
Vertical Layout for Alerts
Is there a way for us to control/customize the format of the alerts we receive between vertical or horizontal? We prefer the vertical formatting over the horizontal as it is easier to read and the formatting carries when we have to forward the email. I have several sheets where when I first set-up the alerts, they came in…
-
need a function to set permission to one cell,or one column
need a function in smartsheet to set permission to one cell,or one column, it means, the viewers can view most of the datas in the sheet,but one or two cells,one or two columns,take the classified column within revenue for example, the datas inside of this classified column just can be viewed by owner and admins, the…
-
Report Builder: Adding Column in report that does not exist across multiple workspaces
We make use of multiple shared workspaces and users then create a report that shows them all line items that they have been "Assigned To". A user would like to be able then have a column available to her to enter her prioritization to work on the items. For example, she may want to use a number system 1A, 1B, 2A, etc. or…
-
Problems with Levels in Card View Mobile
Hello! Does anyone else have issues with Levels in Card View on mobile (Android)? It appears that the Level view gets reset when leaving sheet -- and even worse, If I set the display to "Level 1 and subtasks", and then I add a subtask, it will switch the display to "Level 2"! (and all my main tasks will disappear). I was…
-
Recurring Weekly Tasks
Hello, I've seen a couple of entries related to this, yet I think my question is simpler. Is there a click somewhere that would automatically populate a weekly task? For example: "Review Meeting", from 3/31/18 to 7/31/18, must occur weekly. Is there an option for this, similar to my Google Calendar? Or do I need to copy…
-
When adding a collaborator to a sheet in a workspace, does the message get sent to just them, or eve
When adding a collaborator to a sheet in a workspace, and I choose to provide a message with it, does the message get sent to just the person I'm adding, or to everyone in the workspace? I have searched and have not been able to find a solid answer to this. I ask because when sharing a sheet in a workspace, there is a…
-
RYG ball to change with expiration date
Hello I would like the ball to be red if the date is in the past, yellow if the date is within the next 30 days and green if it is set to expire in more than 30 days. Help? TIA
-
Unable to reach customer service or dedicated sales rep
Several members of my organization have reached out to our account managers many times since we purchased a package. Neither one has responded to emails nor voice messages. If these 2 individuals are no longer with the company, please provide new contact. It is imperative that someone respond back to us this week. Thanks!…
-
holiday period
Hello, I'm trying to add holiday (complete shut down for 2 weeks) period to my project sheet. I've done it in project settings ect. but it is not showing on my sheet. The project should be that much longer and I was expecting to have a separate bar to appear showing holiday period cutting all tasks started and putting them…
