-
Hours of Work Within Task Duration
Hello, I am attempting to solve an issue we are experiencing with using Smartsheet for project management. Here is an example of the situation we find ourselves in... Let's say there is a task with a start date of 08/29/18 and an end date of 09/05/18. The task will be worked on within the allotted time but it only worked…
-
Block Collaborators from Viewing Sheet
I have a few hundred people I need to fill out forms, but I do NOT want them to have any access to my sheet for privacy reasons. Is there a way to get rid of that "View in Smartsheet" link that appears in their update request email? Thank you
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…
-
Conditional Web Form Formatting
I am aware that limiting characters in a form (text) field does not exist. Is it possible to apply a conditional formatting rule to a text field in a form that alerts the submitter that they have reached a specific character count (in the field) prior to submitting the form? For example: When character count is greater…
-
Formula(s) for calculating past due items on a construction punch list.
I'm creating a simple punch list template and would like to add some date calculating functions to it but I'm very unfamiliar with creating date formulas. I'm attaching a screen shot of this rough template with a sample line already entered. I would like to create a formula that will tell me how many days past due items…
-
Formula
I am trying to use the below formula to have an average of answers but it is not working can anyone check the formula and let me know what is wrong =((COUNTIF(CHILDREN(), "Excellent") * 5) + ((COUNTIF(CHILDREN(), "Very Good") * 4) + (COUNTIF(CHILDREN(), "Good") * 3) + (COUNTIF(CHILDREN(), "Fair") * 2) +…
-
auto resizing widgets in Smartsheet reports
Hi there, I'm creating dashboards and they are working well, but one annoyance is that there are many occasions when the data displayed in the report widget, is bigger (usually longer) than the widget frame. Is there a way to set the widget to auto size based upon the number of rows brought back? Many thanks, Matt
-
Cell lookup and linking from another sheet
Good Morning All! Here is my dilemma if anyone can help. I have two worksheets. One has employee ID numbers and a box checked if they have a certain certification. Is it possible to create a formula that essentially says if box gets checked in worksheet A, look in worksheet B for name and check box in worksheet B? Or if a…
-
Copying Alerts & Actions from sheet to sheet
Hi all, I have a set of 5 "Alerts & Actions" that I need to set up on 32 different sheets. Is there a way of "copy and paste" those rules, instead of manually set them up on each sheet? Thank you.
-
How to easily capture Actual Time spent on a Task in SmartSheet?
Fellow SmartSheet Community Members, We have recently started using SmartSheet for planning out a roadmap for initiatives, along with types of roles allocated to the initiative (resources) as well as allocation. We are now looking for creative ways to capture "Actual" time spent on a particular initiative. Here are our…
