-
Is there a way to set a default sort order on a sheet?
I have an open issues list. I would like it sorted by open/closed, then by priority. I can do this manually each time, but I would like that as the default anytime someone access the sheet. Is this possible? Thanks. Wayne
-
Determining duration in Hours:Minutes
Hey guys, I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning: 1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified (Date).' 2. I created a…
-
Is it possible to grant access to a folder without granting access to the whole workspace?
Im hoping someone can help me out, I am fairly new to SmartSheets. In my organization, we have created a Workspace called PMO - Projects. This workspace has a folder for each department and within each department there is a folder for each project we are running specifically for that department. We have configure this to…
-
Shared Filters Not Working
In one of our sheets I want the ability to "force" users to view a sheet through a filter. We have a lot of rows that are added on a daily basis and I want those rows to be hidden if the completed column has been checked. This makes it easier to navigate the sheet and find the open actions that need to be addressed. So I…
-
Set a task that has a set (firm) date and predesessors
Hi, Is it possible to set a task with a "must occurr on date" with a duration and Predesessor? Exmple of use: I have some tasks that people need to complete before I send them on an external training course. The course has a set date and cannot be changed. Therefore I do not want the course date to change in the task list…
-
Merging Cells and Exporting Reports to PDF via the App
Hi there, I love Shartsheet, but one constant aggravation for me is the inability to merge cells. In my quest for a solution, I've come across a few posts on the blog (some as old as 2015) where similar requests were answered with a generic "we'll pass this along to our developers" type response. Just curious: is this…
-
Forms - How to get them to update a smart sheet?
If anyone can help... I created a form on issue tracking. Went to test the form and it appeared to work fine. However nothing updated in the smart sheet. Why is that? Is there something else I should be doing? Where did the update go? Why is it not posted to the sheet?
-
Best Practice: Sharing a Report
I have several sheets that contain course development information. Some of the information is private and not intended to be shared . I created a report for a vendor that pulls information from one sheet (and that one sheet pulls data from 4 or 5 other sheets). Our goal is for the vendor to update the Status column in the…
-
Nested IF for Numbers with Greater Than, Less Than, Etc.
Hello SmartSheet Community! I am trying to get a number that has it's own formula in it, to then be the number that is done in another formula on another cell in the same sheet. I'll go over this to ensure there is no confusion about what I am doing. ====================================================== First, my nested…
-
Using Skype in Smartsheet
Hello, How can i save chat made via Skype in Smartsheet? Regards, Jasmine
