-
Does anyone know how to use "Row Link" in reports?
I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned & active tasks show across all project they're on. This gives an easy link to the project sheets,…
-
Smartsheet Enhancement Request: Change Value Workflow
I would like to be able to use the current workflow system to be able to trigger smartsheet to change a value to a pre-determined static value specified in the workflow. This can be used to simplify many formulas, but most of all it would create a button like functionality for initiating move and copy workflows I have…
-
Change Time into Military
Hi all - Looking for solution to a simple task. Using a form that shows date in this format: 8:00 AM, 9:30 AM, etc., Want to add a second column (that will be hidden from form) that changes this to military time. No calculations involved - only looking for the time conversion. Yes, we could ask for military time in our…
-
Is it impossible to link cells within the same sheet?
I'm using Smartsheet for recording software QA test results. There are some tests that when/if they pass, as indicated by a checkbox, that pass should cascade to pass other tests. The other tests may be in one or more other test groups: Test 1 passes √ Test group a Test 002 Test 003 √ Test group b Test 004 √ Test 005 Test…
-
Auto Sort Smartsheet
I've seen a few threads about this already, but none seem to have an acceptable solution. My particular use case is this: We have a Master Schedule sheet with over 100 active projects (this sheet is updated by various project managers). Every Monday morning we open this sheet and review all projects that match a particular…
-
Resource view by row on sheet
We have a sheet in which we track the various projects on which our team is working. Is there a way to use resource planning to see what is making up the % allocation value in the resource view. For example, what I see now is this: What I want to see when I expand each name is the projects on the sheet that make up the…
-
Cannot edit sheet summary
I was using the trial version and just upgraded to purchased. I'm the admin but I can no longer edit the summary sheet. Any ideas?
-
Reminder visibility
When adding a reminder to a row in Smartsheet, is it possible to have the reminder visible only to the person creating/entering the reminder? I'm thinking this is not possible in Smartsheet now - if it is possible, please advise! Does anyone know if there is a plan to have this available in future? Thanks, Olli
-
Date Range Conflict - Vacation Request Sheet
Hello, I've seen quite a few questions for date range overlap, but couldn't find the solution. The closest I found was the one below, but it was referencing another sheet, not the same sheet I believe, and not sure a simple edit to that formula will make it work for me. Form requests will populate new rows of all time off…
-
Automated Emails and their Date Setting
We are receiving automated emails with the following date format. However, our column settings are set in this format. It's causing a lot of confusion as some people read the email date as Feb 4, but others April 2 - hence the reason for changing the column date formats. Is there a way to get the column formatting to come…
