-
How to fix "Smartsheet app only" displaying in Published Dashboard
Hello All, I want to share a dashboard I've created with my department. However, when I view the published version of it, I get one of these displaying for one of my reports: Can you help?
-
IP Whitelisting to Restrict User Access
Is there an option to submit an IP Whitelist in order to restrict user access to our Corp Smartsheet account? I work with a Bank and almost all applications and data are highly restricted with user access limited to only the bank's systems. I am curious if there are options to limit Smartsheet access via an IP Whitelist to…
-
Issue with cross-sheet =INDEX(MATCH()) formulas
I am consistently coming across an error where my cross-sheet referenced =INDEX(MATCH()) formulas are pulling the incorrect information. I am fairly certain my syntax is correct and that this is a bug. This is happening across multiple sheets I have. I have included one example, but note that I have found this to happen…
-
Datamesh very slow to update
Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?
-
Trainng Matrix for CPD (continuous professional development)
I'm looking for either a sheet or template set to keep track of 15 staff CPD courses. There are 10 sections they must complete over the year and a minimum time requirement. I had set up a sheet where multiple contacts can be against each course but I now realise this makes getting the summay information I need a little…
-
Why can't I update a column cell in an update request if it already contains content?
Hi, I have a cell which has a target date in it and I need individuals to update the target date if it will not be met, but on my update request email (sent via automation) I am unable to update the target date. Why is this? Thank you,
-
Blank/empty attachment in preview mode
Hello, I have uploaded some PDF files to a spreasdheet; if I download them, they are ok, but if I open them in preview mode their content does not appear, the document is blank. This is happening with a few PDF attachments, but not with all of the attachments of the sheet and I can't understand why. Does anyone have a…
-
plotting the same day multiple times
I've set up a scatter plot to display the status of a task against the created date and priority rating, I have multiple points for the same day at different priorities and instead of stacking these points vertically the chart widget is plotting the same day multiple times for each point, is there a way to fix this?
-
Compare submissions
Hello! I would like to compare submission such that older submissions from same field "Name" are moved to different sheet. I can add a helper column called "Older" and would like to either populate the older rows with the word "Older," and number to signify it is older, or a simple yes/no dropdown. I currently have a…
-
How to show data of previous working day?
For a stacked column chart on a dashboard, I count the number of applicable cases daily. The current formula shows NO DATA on Monday because TODAY(-1) is Sunday. =COUNTIFS({Customer Escalation Region}, $Region@row, {Customer Escalation Request Reason}, "Close Gap", {Customer Escalation Request Date}, TODAY(-1)) I'm…
