-
Is there a way to display elapsed time for a project?
Hey everyone! I have a project which has the obvious "start" and "end" date columns and Smartsheet automatically calculates the actvity duration. Is there a formula or something which will calculate and display "elapsed" time from start based on the current date? Thanks! Steve Stutz
-
Hyperlinking
How do I hyperlink to a cell on the same sheet? I would like to click on a cell and be taken to another page in the same sheet.
-
Changing Font Size In Gantt Chart
Hi, I am very new to SM and can not figure out how to make the font on the Gantt sheet area larger. I made the details larger but it did not transfer over to the Chart. Help?
-
Freeze rows
Is there a way to freeze rows in SS? It would be useful to keep a parent row in view while scrolling through child rows below it
-
Automatic formula fill
It says in the smartsheet help files that inserted blank rows should automatically fill formulas if the new row is between two contiguous formulas... For most of my sheet this is true. However, I have one very long formula that identifies a month based on the date and it seems to stump the autofill. Is this intentional or…
-
How to Schedule Tasks Based on Resource Availability?
I'm looking for a feature or function that will automatically schedule a set of tasks based on the availability of the resources assigned to the task. I've got a list of tasks that are each assigned to a resource and estimated with a duration, but these tasks do not have start dates and end dates set (yet). Is there a way…
-
Attachment - Folders / Subfolders
In the attachment section, would it be possible to have folders / subfolders? I would like to store and organize using folders. For example, I would like to group excel sheets together in a folder, create a folder for my pdf documents, and create a photo folder. Please see the screen shot below: (I am aware of the Box,…
-
Can hidden field on web form designate parent-child row status automatically?
Our Smartsheet has a client name column along with a designator column that indicates what type of work we are doing (M, S, or C). We have a web form set up for each (M, S, or C) using the hidden field so that when an "M" form is submitted, conditional formatting tells it to bold and back fill the row. Is it possible to…
-
Countif(Children(), Criteria)
Hi I use this formula to count how many Red (RYG) there are for a parent task Countif(Children(), "Red") I find that I have to place this in the parent line and in the RYG column What do i do if I want to count the "Yellow"s as well? By Extension, in Status we have more than 2 statuses so how do you do a countif for the…
-
Reply to a comment received via email
so, i've received an outlook email notifying me that a comment has been made in a certain row. What i cant see is a way to click directly back to that row from within Outlook in order to respond. How do other SS users reply to comments that you receive via email please? Thanks, Si.
