-
Report Publishing...
I want to be able to publish a report link for editors to update a project status the way I can publish fully editable links via the sheet itself. Why can I only publish secure links for reports that require a login? I want editors to have access to change information in a report without logging in. What am I missing?
-
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…