-
Counting Based on Two Items
I am making a sheet to track the number of proposals we send out and how many turn into projects. I want to be able to count them by which Project Manager did it. So I have a PM field for the Project Managers initials. I was using fields for each PM's Proposals. The formula I used was COUNTIF(PM:PM, "RM") for example and…
-
Report Error
Hello, I am trying to create a report that brings in multiple date types so that I can use the calendar view to see my marketing and PR activity. I created a marketing campaign tracker and PR campaign tracker. The marketing campaign tracker has a launch date and end date and the PR tracker only had one date. I tried to…
-
Past Due Reports
GOAL - Tasks Past Due Report for Multi Sheets I have several sheets with the columns set up as seen below: (Type 1) Rows have Tasks with a Contact under Assigned to, "Required" column has a symbol and % Complete is not required so it's left Blank. (Type 2) Rows have Tasks with a Contact Under Assigned to, "Required" column…
-
Conditional Notification / Alerts
Hi Smartsheet Community, I recently posted a reply on the smartsheet blog (https://www.smartsheet.com/comment/46032#comment-46032) and Diana Ramos kindly replied letting me know that Conditional Notification might soon be available. Diana asked me to add a thread here to capture and direct the programmers to ensure our…
-
Report for when a column has been modified in last X days?
Hi all, starting with a sheet that includes all marketing tactics for all of our projects, I'd like to build a report that rolls up every row that has had column "Designer" modified in the last X days. Is that possible? I can't figure out how to do so. I cannot add any formulas or conditional formatting to the master sheet…
-
Keeping parent Task during filter search
I have been using the Parent Task as a header for child task below. The child task has an owner, the header does not. I'm in construction so for example the Contract header has child items such as site visit, develop scope etc. My owners don't want to see all the items that they don't own and I have a filter for each owner…
-
Can I use cell history to calculate how much time has taken between two non-date cell types?
Hello SS Community, I have a sheet that is used by medical professionals. We need to calulate the time between a cell that is filled out when a patient arrives, and one that is filled out when they leave. The cells are text based and not date type, nor are they cells where the user is typing in a time (so I cant simply…
-
Reports including values that should be excluded
Hi there, I am building a report and when I indicate I want the "What" to include all values below 100%, the report still includes the 100% tasks as well. I have tried to entered the in between 1-99 and 0-99 values too buit it still spits out a report including 100% martked takss. I feel a bit puzzled by this. Can anyone…
-
New approach for status on a project plan
our current project plan is driven by organization functions, the item details roll up by function. We want to move towards an outcome based plan, this would be leveraging the same plan but report the status by workstream instead of by function. Each item is tagged with the workstream. smartsheet does a great job rolling…
-
Enhancement Request - Filter Columns
I believe it would be greatly beneficial to be able to filter columns as well as rows. The saved filter profiles was a great enhancement that allows sheets that are used for data tracking to be sorted to data subsets. If you could also save which columns are to be displayed to the filter profile then you could create views…