-
No Drop Down entry for the week
I am looking for a formula to indicate if there are no entries of an item in a drop down menu within a particular week of the year. Below is a brief rundown of what I have accomplished, and what I desire. I am looking to create a report or dashboard to reflect if an inspection on a particular device has been completed for…
-
COLUMN CHART COLOR
Hello! In a column chart, can we change a specific column color since it is still a pending information, and we would like to highlight it. Merci.
-
Email Link In Dashboard
Hi! It's been requested that I provide some contact info on a dashboard including an email link. For some reason, I cannot figure out how to make the text in the email address link to open/create a new email. Am I missing something? I've tried all kinds of widgets on the dashboard and even tried to find external ways to…
-
Today() Function not updating
Has anyone else noticed that the today function is no longer updating consistently when sheets are triggered through either cross sheet references or through an automation that records todays date. I have used these procedures successfully for years but in the recent weeks they have stopped working. I can't go back and…
-
IF/And/Join/Collect
Hi Smartsheets community, I am trying to create a summary field in a sheet that joins all the text from one column that meets these criteria: has a created date less than 20 days old has a label of "decision" in another column OR a star for priority in another column. I have a sheet used to track RAID entries, and…
-
Merged: Per-widget background colors
This discussion has been merged.
-
Merged: Place column/bar chart value labels within columns/bars
This discussion has been merged.
-
Smartsheet Application Zoom Function
Smartsheets does not support browser zoom levels under 90% and begins to misalign rows, columns, dashboard widgets and more. This is still an issue within the smartsheet application and continues to shift and misalign data and widgets. Specifically building a dash board is very challenging as the alignment tools made to…
-
Why would a formula work on one sheet but be #unparseable on another?
Hello All, I am trying to use a formula I use on one of my sheets to collect data. It works great, but I made a new sheet to capture the data as the other one is messy as I was still learning. My Formula works great on the original sheet, but when I use the same formula on my new sheet it comes back #unparseable. This is…
-
Edit Dashboard within Workapps
Currently, there is no functionality to allow users who have Admin / Edit access to a dashboard to edit that dashboard in Workapp - there is only view or hidden functionality. This means that the user has to be led away from the Workapp to edit the dashboard instead of being able to stay in the Workapp to complete the…