-
Project Resource View
Hi: I'm looking for a way to where the Project Resource View will list actual Task Names against each resource in my project sheet instead of the smartsheet file name against each person. . Is there a way the Project Resource View can be tailored and utilised as a resource management tool?
-
Sights: Sheet Name Link issue
I am having an issue with my Sights where I have a Report Widget and within the report is the "Sheet Name" link. From the Sight, the first time I open, the Sheet Name link does not work. I have to first click in any other column to open the Report, and then the Sheet Name link will take me to the row on the Sheet. I can…
-
Sum of hrs utilized per client
Hi Smarties, I created a time tracker with each column with drop down list for different clients. 1. I want to sum all the hours used per client and to appear in one cell per client, so I can link the cell to auto populate. I am familiar with step 2( cell linking). Can someone suggest how to run the report on a sheet with…
-
Changing Fiscal Year Start YEAR in Gantt Settings
It is possible to change the fiscal year to be the previous/current calendar year, vs the default of current/coming calendar year in the Gantt settings? My company uses a delayed April start. Thanks!
-
Website migration project
Hello, I'm a new Smartsheet user, managing a large health care website redesign project. We have a large amount of content to move from an older CMS to a new one. We're also moving from a static to a dynamic site environment. Are there any users here who have used Smartsheet to manage and track a large content migration…
-
Max number of entries in drop down list?
Hi; Is there a limit to the number of entries in a drop down list? Would a list of 1200-1500 names have an impact on performance? We don't need validation or conditional formatting (e.g. red for a value is entered that is not in the list). Are there best practices for a task like this? Thanks in advance, Andrew
-
Web Form - Signed
HI all I am creating an onboarding web form however we need the form to have the ability to be signed, I know SmartSheet has an app with Docusign but this is very expensive Does anyone have any tricks or ideas of how this could be done Thank in Advance
-
Feature Request - Auto format for ranges
It would be extremely convenient if we could set our autoformatting rules for a Row, a range, or even the whole sheet, instead of just one column at a time as is the current configuration. EXAMPLE: I have 15 columns that I would like to apply the same 6 formatting rules to. Currently, that means that I have to define 90…
-
Hide or reveal a web form question based on answer from previous field
Is there a way to hide or reveal a question/text input field in a web form based on the answer from the previous question? For example, I am creating daily truck check forms for our paramedics and one question is "how many back rafts are there?". The dropdown list choices for them are "3", "Restocked", "Ordered" and…
-
Adding Workdays to a Formula
Hi SmartPeople - I am trying to create a formula that adds "work days" to a date. Example: I have a "Date Reported" column and a "Date Due" column. The "Date Due" column is a formula based column that should add a specific number of days (either 5, 10, or 20) based on a given priority in the "Priority" column. However,…