-
Automate harvey balls with completion status
I am trying to automate the RGY Harvey balls in a sheet based on the status of the Full/quarter/half/three quarter/full Harvey balls.Below are the statements that I want to use but I was hoping to get some help putting them together in a nested if statement. if End Date is before today's date and Completed is full then…
-
Best Way to Have a Back-and-Forth with Non-Users?
I have a sheet with info for a few hundred people. For privacy reasons I cannot share it with them, because they cannot view other people's rows (a selectively hidden feature I've put in a vote for). So I send everyone their information in an update request and ask them to fill it out. I then see their answer, respond, and…
-
Smarter Dropdown List Manager
Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that list. Our Developers, using the Smartsheet API have created just that solution, in fact we have assumed that users will want…
-
Countif/Countifs Date Range
I am trying to count a certain criterion that occurred within a specific date range and I can't seem to get the formula right. =COUNTIF([Training Date]:[Training Date], AND(@cell >= DATE(2017, 6, 1), @cell < DATE(2018, 5, 31)), Role "Clinical") I am trying to count, for example, how many clinical staff were trained between…
-
Frustrating split of functions vs cost of license types
One very interesting thing for me is the curiosity I get from people around me when they see me using Smartsheet. The low threshold of knowledge to get into it and the "mimic" of spreadsheet (excel) view behind it makes it so much more attractive than MS Project for example. Often when I bring up MS Project as a possible…
-
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…