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.

Transferring ownership of a workspace or sheet
I am trying to change owner of a work space to any other licensed user. The option to remove me as the owner or change the user from admin is not available at either the sheet level or workspace level. Has this changed since the last round of upgrades?
View sheet comments in column in main sheet view
Hi - Is there any way to view comments like a chat window in a right hand column alongside a sheet? The comments in pop ups seem too hidden. Thanks
Inter Project dependencies
Hi, I have multiple projects to be managed under a program. I have a task1 under Project A which has dependency on task2 of Project B. How can I mark dependencies between two project tasks? thanks, Pragati
Help with RGBY Balls
Hi Community, I have tried everything I know and I haven't been able to figure this out. Below is my formula =IF([% Complete]31 = 1, "Blue", IF(TODAY() - Finish31 > 0, "Red", IF(TODAY() - Finish31 > -4, "Yellow", IF(TODAY() - Finish31 > -5, "Green")))) What I'd like to have happen is if % Complete = 100%, Blue, If Today -…
Edit row from report
In a sheet's card view there's a shortcut ('Enter') to open edit form for that row. There's no such shortcut or option in standard grid view or a report which is the main working mode for me. Currently the only option I know of is to click on the row actions button and select 'Edit'. This is a lot of manual clicking…
Gantt View End Date
Is there a way to 'fine-tune' the zoom in/out feature in Gantt View? Zoom in is too much, and zoom out is too little. My timeline is complete in May 2020, but when I zoom out it takes me all the way through the year 2028. Is there a way to say don't go past May 2020? Hopefully this makes sense. Thanks for any feedback!
Change height of the column title (top) row
Is there a way to change the height of the column name row? Some of the column names are longer and I want to be able to wrap the column name. Appreciate your help.
COUNTIFS to Calculate Tenure within a Date range
I am trying to count the number of our employees that leave in the first 60 days if they were hired in a certain month while referencing another sheet. In my original sheet I have 2 date columns (Hire date and Departure date) then a count field that calculates the net days between the two. This is the formula I have and I…
Notification when a shared user information is edited
Hi Everyone , Can you tell me how to set an alert as a sheet owner , to reveice notifications when an user is added , withdrawn or whose information is edited on a sheet ? Thank you in advance .
Charting on non-primary fields
I have an Risks, Action Items, Issue, Decision and Questions.. (RAIDQ) sheet. The description is the primary column (field). I have created a few reports using the RAIDQ as the source sheet. I want to create a charts in a dashboards RAIDQ by Priority, RAIDQ by Status, RAIDQ by Category. I am unable to select any other…

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