-
How do I set my grid/sheet by default to show current date at the top and oldest date at the bottom?
How do I set my grid/sheet by default to show current date at the top and oldest date at the bottom? When a person reviews/opens my grid/sheet, I need it to show current date of work at the top and oldest at the bottom by default. I know I can create filters but can a filter be set as a default? makes sense please and…
-
Adding "mailto: " feature/ widget to Smartsheet dashboard as a functionality
Hi, I have a request to make to Smartsheet Support group, and I am sure a lot of Community users would resonate with me, for this feature! Adding "mailto: " feature as a feature to dashboard widgets. We know that there are a lot of sites that offers URL shortened such as https://is.gd/ and https://bitly.com/ . But how safe…
-
Deleting multiple Smartsheets
Hello Community, I am brand new to SmartSheet and I've been tasked with "cleaning up Smartsheet". I have been granted Site Admin permissions. Is there a may I can access sheets not explicitly shared with me? Is there a way for the site admin to delete sheets? There are over 2000 sheets, workspaces, etc. and more than half…
-
Open a New Window From the Dashboard
How do you set up the calendar (from the calendar app) imported via the web content widget to open in another window?
-
This month or previous month in the Report
Hi, I need would like to have reports where all the result are from "this month" or "previous month" but I don't see such filters in When? Option. Can someone help me with that?
-
Issue with Progress calculation of weighted values
Good morning, I'm calculating the completion progress for a project with weighted values on individual tasks. However, it's only calculating 50% of the actual progress. This is the formula that I'm using: =AVGW(PROGRESS:PROGRESS, [WEIGHTED VALUE]:[WEIGHTED VALUE]) Here's a screenshot of my sheet: Please show me what I'm…
-
Copy rows with automation: destination sheet not appearing.
Good afternoon, I am trying to set up and automation that will copy a row when a field is changed. I would like to copy it from one sheet to another. I am able to set up most of the workflow but when I try to select the sheet to copy to I can't see it on the list of available sheets. I am the owner of the new sheet and…
-
Count Up Timer
Hey all. Brand new (3 days) Smart Sheet user. I am working on an exercise with my team and would like to have a running "count up" timer (stop watch if you will) in a dashboard that shows from the time we kicked off to where we are currently Hrs:Min:Sec able to show for about 48 hours. I tried importing a few timers but…
-
Formula assistance
Hi, I currently have a sheet set up where I am calculating the total revenue generated for all the tasks listed underneath the main header using the =SUM(CHILDREN()) formula. All the tasks listed underneath the header in the status column is being classified as awarded, cancelled, pending and unsuccessful as shown in the…
-
Attachments in notification for Update Request or Alert
Hi, I have read all the suggestions on how to get an attachment added to an alert in a workflow or Update Request. I have done both scenerios and the attachments still do not come through. Has there been any update to this? I see this has been an issue going back to 2019 and continues to be an issue. Any help is…