-
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,…
-
Assigned To Notifications Not Working
I have several sheets with Assigned To notifications set up and they are not sending emails upon assign. I'm hoping I'm doing something wrong, but I've searched these boards and it looks like I have it set up as suggested. Here is a pic of my settings. Please help!