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.

SUMIFS calculation
I have entered the current formula but get invalid operation, not sure why. Seems to be something with the >50000 as the formula works when I remove this. =SUMIFS([1 July 18 - current]2:[1 July 18 - current]396, >50000, [Contract Status]2:[Contract Status]396, "red") Help would be appreciated.
How to print a list of column headings?
Is it possible to print or create a list of just the column headings used in a sheet? And, ideally, include any list (e.g., values listed for dropdown boxes, symbols) associated with each heading? We have a sheet with over 50 columns and would like to find a way to keep track of the headings and their lists. I've checked…
Widget in Multiple Dashboards
I'd like to have a particular chart show up in multiple dashboards. Is there a way to copy or link the widget between dashboards? Having to re-create each time will be pretty time consuming. Thanks.
Default Card View Always Show Field Labels Caret Toggle
How can I force Card View to always show the field labels associated with data on all cards? I don't want to require users to click on the little caret symbol that toggles labels to display on each card... I want all field labels to always show on all cards all the time.
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.…

Popular Tags

Trending in Smartsheet Basics

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…
Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags