-
When creating/using forms, is there a way to have the formatting of a entry pull over to the form?
I am looking for a way to enter a list into a form and have it pulled into the sheet "stacked" instead of run together.
-
Linked cells not showing in dashboard report
I have a dashboard that surfaces a report in which the duration value cells is blank. The report source data is in a row report. The duration value is visible in the row report. The source the duration value is a sheet in which it is also visible. I have refreshed the report but as the duration is automatic I cant do much…
-
Reporting Question: create a report that aggregates Column information
Hi, I am trying to create a report that aggregates Column information based on a Condition. For example I have the following columns: -Track -Track Status -Days I would like to know a roll-up of the status by Track and then use days as a filter criteria. So if the days are 30, it would show status for just those that are…
-
Viewing Deliverable for Multiple Projects by Month - NOT in a Gantt : )
So...any creative ideas for how to achieve something similar to the attached image IN Smartsheet? We want to visual represent high level deliverables across multiple projects for the entire year by Month, however, NOT in a Gantt view and we want it as a 1-pager. Thoughts? Ideas?
-
IF Statement-If text is updated in my "Comments" within the last 5 days I want to return Yellow Sta
Looking for formula help. I have a comments column that I want to make sure is never more than 5 days old. If the comments field is updated with new or different information - I want to return a Yellow star to the Updated field or a date for which it was updated on. Is this possible? Thanks Molly Morton
-
Why am I only seeing system columns in Report Builder?
Hi, I am having an issue showing columns other than System Columns in the report builder. As you can see from the attached I have my sheet selected. What am I missing? I tried saving and going back in, but this did not fix this situation. Thanks, Paul
-
Using Project Management Templates
I'm using the PM templates and the templates utilize a section in the project plan that is called Project Information. It's handy b/c you can use this non-task related information in dashboards. What my issue is w/in the Finance section under Project Info - there is budgets and actuals. I am trying to utilize the children…
-
Populate a column based on a Smartsheet User Profile data
Is there a way to access the fields in a Smartsheet User Profile. I have an Assigned To column which can contain a single Contact List type. Each single contact in Assigned To is also a Smartsheet User. I have a corresponding Assignee PH# column in the same row. Is it possible to populate the Assignee PH# by doing a…
-
Cross-Sheet References with Contacts
I don't know if what I'm trying to do is not possible within the application or if I'm just missing something. I have created a form that the user selects their name from on the dropdown list. On the corresponding sheet, I'd like to populate their email address and office code by using a master contact list in a different…
-
How to deliver notifications by individual row after multiple row update
Hello Community! I would like to to have smartsheet deliver a single email notification or Microsoft Teams alert after a user updates multiple lines. Right now, I can update multiple lines on the sheet but only one email or notification is sent with the changes grouped together. I want the individual lines that were…
