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.

Is it possible to display 2 different date range diplays in the Gantt Chart?
Hi, In the Gantt Chart, is there a functionality or a way that we can see 2 different date range displays? For example for a project tracker, 1st date range would be the planned start date and planned end date and the 2nd would be the actual start date and the actual end date so it would look like 2 bars (with 2 different…
Copy/Paste Cells from Excel into Smart Sheets
I have an excel file and a Smartsheet. I am unable to copy paste from the excel into the Smart Sheet. Am I missing something? Video HERE
Insert a date six weeks before key date
Hi All I am trying to create a formula to insert a date six weeks before a key date. This earlier date will be the commencement date of the tasks. Example: We have a building that has an end of financial year on 30 July 2018. I need to start the first task mid June and also run this start date as the basis for the…
Adding HYPERLINK (to other smartsheet) inside a drop down menu
Hi I have multiple employees name in my drop down menu. They all have an individual employee page. Could we add a link to their name when I create my drop down menu , inside edit column properties? thank you
cannot delete ref links from vlookup
Hi I tested vlookup function and I created a new sheet .I deleted this new sheet but now in my master sheet it's still outbound to ref unknown sheet. I cannot delete that link...
IF AND function
First time here and new to Smartsheet. In a cell I have a number. Say 400 In another cell I have a specific date. Say January 1, 2020 What I want to do as a task start date in another cell is: If the number in the cell falls within a number range on another sheet I want the task start date to be, specific date – 18 months…
2 week task for 2 hours each day
Is it possible to have a task with a duration of say 2 weeks, but only allocate a fraction of the day’s hours to the assigned resource? For example, John Smith is assigned Qlik development that will last for 2 weeks, but will only be developing for 2 hours/day. I know it’s possible to change the default length of a day…
Internet explorer stops working while trying to open an existing sheet
I have a new user that is encountering an issue when she tries to open an existing sheet. She retrieves an error that Internet Explorer has stopped working. she has to close and restart. the sheet is approximately 600 lines and looks like a standard project sheet. She is able to open other sheets without an issue but it is…
Secure Login & Password
Hi, We want to secure User id and Password for my account by Generating codes to Mobile or the email id. We have 3 license and the users using out of office to access the data, I want to make sure the login to new system will create a code like that Gmail generates the 2 step verification code. Please suggest. Regards,…
Resource Management
Hey Guys, unsure if this is possible but lets see. I am going to be using card view as a kanban style work stream for my team, each card will have an estimated effort as to how long the job will take and an actual field for the actual time. each of my staff i could say has 5 hours a day free. what i am trying to achieve is…

Popular Tags

Trending in Smartsheet Basics

Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags