-
Comment notifiation allows for the reply to go directly to the Comments for that row
We are managing an "issues" list. The issues are being collected using a smartsheet form and its working very well. Both name and email address are being collected in the form. Because issues take many iterations to solve there are lots of back and forth comments. When a user who entered an issue receives a comment back…
-
Would like to create a filter that hides completed tasks BUT only when parent row is checked
Hi there, Ultimately I would prefer that tasks that are completed are archived, however in lieu of functionality, I am looking to create a filter view where tasks marked as "done" are hidden. The problem is right now the filter hides ALL tasks marked done and I would prefer it hide ONLY the parent and its subtasks. Please…
-
Dashboards & Reports
I have created an announcement report for announcements on Dashboards. I highlight the most recent entry in the report, but when I view the report in the Report Widget on the Dashboard, the row is not highlighted. Grid/Form--> Report --> Dashboard How do i get it so my formatting on my report appears in the Report widget…
-
Percent complete IF Formula
Hello, Please assist with a IF formula for a total percentage completion of Task1, Task, Task3. If Task1 is ≤330 Days it is considered 100% complete. IF Task1 is ≥331 days than the task is 0% complete. I would then take Task1-Task3 completion % and average to show total percentage. Limiting this to just few helper columns…
-
Project Management Office - Intake Sheet Numbering
:-( ... I am currently using the Project Management Office Template Set, which is pretty great. However, I didn't realize you could change the numbering scheme before you started. I was given the advice that if I wanted to fix the numbering scheme with my current project load (about 38 project), that I would have to delete…
-
SUMIF not adding correctly
I'm trying to add Units Used of a particular Raw Material with a certain Inventory Id. I've used the formula: =SUMIF([Inventory ID]:[Inventory ID], [Inventory ID]@row, [Units Used]:[Units Used]) I am expecting a positive number, but the result it "0". If I copy the formula to all the rows in the Total Used column, all…
-
Form not populating sheet
I created a very lengthy form that I tested several times before sending it out to colleagues. Now that I've asked people to submit entries into the form, it does not seem to be populating the sheet. I've scrolled down to see if the entries are coming in at the bottom of the form, and I have also checked all filters. Does…
-
Cell History showing people making changes they did not make
Recently we have had an issue where a cell keeps being updated and shows it was an individual user (multiple) only for those individuals, myself included, confirming we did not in fact edit that cell. It is a formula driven cell. I have checked the cells used in that formula and those have not been updated. Anyone know…
-
Attachment Download / Upload Speeds
I am having a great deal of trouble downloading attachments from my Smartsheet. It is extremely slow, see below. 45 minutes for 15mbs (eventually it changed to "2 hourse left" and then just stopped). For comparison, I downloaded a similarly sized file from Google Drive and it took about 15 seconds. I can understand it…
-
Create a simple table for dashboarding
Hi What's the easiest way to create a very simple table which contains a summary of data from a grid which collects survey responses for dashboarding I want to be able to create a summary by "Account" with a count of various statuses [see example below] Account Open Closed Apple COUNT Account = Apple & Status = Open COUNT…
