Product questions?
Sign in and ask it here! The community's got your back.

Smartsheet Basics

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

how do I consolidate data from multiple sheets so I have all data on one sheet
Employee Time Sheet
Saw this as an option for a time sheet. I get the parent/child rows and how all the math works. What i dont get is how each of the parent rows are created, if i have a form for employees to submit each week with their time entered.
Filter a column to add all of a key word to the bottom
I am wondering if there is a way to filter on a keyword in a column, and move all rows containing that to the bottom of the Smartsheet. Another option would be if I am able to sort so all rows highlighted a certain color drop to the bottom?
Use case Question
Hi community. I am working with @Laura Polson to help our field staff be able to track their schedules while out visiting stores for various reasons. We would like to find a way to show visibility based on hierarchy (district to regional to territory) for assigned stores. For example - if I am a District Sales Manager that…
Finish Date Static vs Duration Static
Can the Finish date be static and have the start date and duration dynamic? Example: I have Task 1 and Task 2. Task 1 has a duration of 5 days and Task 2 has a duration of 10 days. Task 2 has a dependency on Task 1. But Task 2 has a due date that cannot change. If Task 1 goes over the 5 days by one day, I update the…
Process Question - how to manage multiple sites in a portfolio
Hi everyone - I wonder if someone can share some ideas on how to address this issue I'm having. I'm building a real estate management solution in Smartsheet. I have 50 sites, each with 1-5 suites. As an owner, we have 50 items to manage. As a landlord, we have many, many options of site/suite configuration. I have a master…
Approval Workflow: Rejection "Alert Someone" not working
Hello, I am running a 3 stage approval process. If stages 2 or 3 REJECT the approval I have it setup to "Alert" the Stage 1 approver. I have triggered the workflow now 3 times and each time REJECTED the approval at stage 2. The workflow updates the state to Rejected but does not send out the notify alert. I have also done…
Need help as vlook up not working
Hi smartsheet commuinty, have an issue on vlook up formula as telling me "no match" but i did key in the formula as the data cell 12th column is not being taken.
Programme Status based on %complete
Hi There, Apologies if this has been addressed elsewhere, I could not find anything similar. Are you able to status update a programme so to update % complete and the resequence the programme task to start after the today line?
Update Smartsheet from a Google Sheet
Hello Everyone I am looking to find a way to update a Smartsheet from a Google Sheet source sheet. I have a main Google sheet source that our business uses. I was able to import the Google Sheet into a Smartsheet. But now I need a way to update that Smartsheet. The Google Sheet, used by our business folks gets updates…

Trending in Smartsheet Basics

Applying same conditional format per column
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Identify "youngest" date from "Created Date" Column
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
unable to edit fields
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…

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

Watch video

Smartsheet Basics

Categories

Popular Tags

Smartsheet Basics

Discussion List

Categories

Popular Tags