-
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…
-
Sending Row from Report - Selecting Columns
I want to use the 'Send Row' function as a confirmation to clients that certain tasks were completed. The Report includes about half the columns from the Referenced Sheet, but I only want to send 4 or 5 columns and no attachments with these confirmations. So I clicked the "Edit" button to deselect the columns, and I ran…
-
How to organize smartsheet for multiple column updates monthly
I would like some suggestions on how to use smartsheet for my application which collects data for a metric. For my application, I have 50+ projects that are spread across multiple businesses. For each project, each month the owner needs to enter 4-5 data values to report the monthly metrics for their project. We need to…
-
Displaying a Report Full Size on Company Intranet Site
I have created a summary project report that is displayed on our company's intranet site using the embed code. It does not fill the page and the viewport becomes very tiny on smaller screens. Is there any way to display the report in full size?
