Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Formatting Question for Task Status Report
Hello! I'm hoping someone can give me some tips on formatting a report that I've built. It's essentially a list of every task that either started in the last 3 weeks, or is ending in the next 3 weeks across about a dozen project schedules. It also includes whether or not each task is "On Time", "Running Late" or "Overdue".…
Parent Status Condition Logic Dependent on Children
Hi! I am looking to have my parent header updated to complete once all children are complete or display in progress if any of the children are still in progress. If all children are Not started I want the status of the parent header to be not started. I am sure this is simple....but I stuck. Thanks!
Dynamic Dashboard based on the month/date
I have a monthly sheet of various stats that get collected on a monthly basis. Therefore I have my columns as Jan/Feb/March etc. and my rows as my various measures. what i need help with is, based on the current month (march), show me the previous month's values. so that when i look at the dashboard now, i see february…
Populating Reports from multiple sheets in a Workspace
We have a considerable number of sheets in a Workspace; identical structure for each, just different client. Within each of those sheets, different users are assigned specific line items (tasks). A report is set up for each user showing the tasks from the various source sheets, that are assigned to that user. At the moment…
How to account for outside test house closures?
Hello! Part of our Manufacturing process may include having to send samples of our product to an Outside Test House and waiting for results before proceeding to our 'finals'. We know the weeks this test house will be closed throughout 2020. Is there a way to indicate this in our Gantt chart when setting up our projects? In…
Sending Email Group a form
I am wondering if there is a way to email a survey form to my group and when they each respond individually their responses fill in 1 row at a time. Example: I have 10 people in my group, they each respond to the survey and I will have 10 rows of responses. Currently, if I send the form to 2 or more users the first persons…
Conditional Formatting based on due date
I have a due date and want to have the "Risk" green if the due date is more than 15 days out and the Status is not "Complete". How do I do this?
Card view: Arrange cards by criteria?
Hi there, I have my sheet set to show rows in descending order of dates, from most recent to oldest. However, when I use the card view, it shows the cards in the reverse order -- from oldest to most recent. Is there a way I can sort my cards in the same order as my sheet? Thanks! Jackie
Needs assistant to Creating a new on line form with link to master sheet
Hello All I am looking for professional help for creating on line forms and with a link to master sheet . see attched. Please quote me best price . Thank you Steven lau Whatsappp : +6594555212 lygsteven@gmail.com
Can I get a notification when a new collaborator has been added to a sheet?
Hello, I have multiple sheets and dashboards created for different departments. We are allowing editors the ability to add collaborators to their sheets. I need to track who has been added as a new collaborator across all the multiple sheets so I can add these users in their specific groups (which grant them access to view…

Popular Tags

Trending in Smartsheet Basics

how do you freeze a full work sheet
Prefill a form response from another sheet
I have a project tracker sheet and am trying to set up a flow to send a survey via a form once the status of the project is changed to complete. I would like the survey to prefill with the project name from the source sheet, of the project that was changed to closed. Is this possible? The form results (survey results)…
Can you preserve password protection in .pdfs that are attached to a form submission?
My colleagues need to submit Smartsheet forms with password protected .pdfs attached. The form submissions are being received as expected, and you can see the attachment in the proper row but when you go to open it (either directly or after downloading), an error message pops up, "We can't open this file. Something went…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags