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.

Sending approved requests to Outlook Calendar
I am looking at creating a form that will allow my team to submit requests to go into the field for work. This is part of their job and I just need to make sure it is more formally captured with information about where they are going and what they are doing. Can I create a form and then once I approve the request it adds…
Modifying resource views
Good day and thanks in advance! Doing as I understand it's supposed to, when i open a resource view and select (and expand) a resource, all sheets with that resource are there and roll up to the total resource allocation for that resource. My challenge is that I have multiple earlier versions of plans I've developed, with…
Report for files not modified in last 45 days?
Is it possible to create a report to list all files (sheets) in a folder not modified in the last 45 days? To be clear: I know how to run a report that shows the ROWS modified within the sheets. I want to know when the SHEETS themselves were last modified. Background: Currently I have a folder with hundred of sheets. They…
Day and Time
Hi, Is there a way to track time of day by task? Thanks Cheri
Rounding to a Floor
Hello, I'm trying to round a calculation to the lowest quarter (ending in 25,50,75 or 100). The Excel formula is =FLOOR(132,25) equals 125 =FLOOR(168,25) equals 150 Smartsheet doesn't recognize the FLOOR function; any help is appreciated
Not able to moving cards into touch screen monitor.
Hello, I'm using the smartsheet on the touch screen monitor and I have set the appearance as a card view on Gantt charts. With using the mouse I'm able to move cards, But while using the touch on the screen, I'm not able to move them. Please see the attached snap and let me know if there is any solution to resolve it.…
Delete Range Lookups
Ive reached the 25000 cell limit for the range lookup for the VLOOKUP function. Problem is, Ive forgotten where all the range lookups are across multiple sheets. What we nee to know is where we can find a list of the named ranges. I know that they are a named range because when a range of cells is selected it names them…
Is my alert too redundant?
Did I set up this alert to be too specific? I want to have an individual notified when a row to which they are assigned to has the status change to "In Progress". I'm trying to test it now but have doubts about the "In a row where any status is In Progress" line I included. The red in the picture is where my colleague's…
Send alert/notifications including headrow and children rows in the attachment
Hi All, I want to send automated notifications to my employees containing their absence records. To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment. So far I can only do this…
VLOOKUP reference another sheet with parents
We are looking to create a formula to reference a date in another sheet (sheet 2) and than see if the referenced date in (Sheet 2)is before or after the date in the formula sheet (sheet 1). Forcing a check box or adding a visual identifier to the formula if it is true would be ideal. I've created this VLOOKUP formula, but…

Popular Tags

Trending in Smartsheet Basics

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%
Remove workspace shared users from 1 sheet
We are working on setting up our Career Reviews in Smartsheets. We have a group of all staff that has access to all sheets in our workspace. I want to remove them access from just the Career Review Sheets. When I do that it says it will remove them from access to the entire workspace, which is not what we want. The only…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags