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.

Find and Change Resources in Alerts
We have a staff person (A) that retired and is being replaced by another staff person (B). I ran a report to tell me where she (A) was allocated as a resource in the various sheets, and was easily able to change those tasks to the new resource (B). However, I know that the retired person (A) also received alerts based on…
Is there a column or range limit to Vlookups?
Is there a column or range limit for Vlookups? My Weeknumber I'm referencing is in column 1 and the number I need is in column 33. The error its giving me is #Invalid operation. It seems that I can handle 31 columns but anything after that, it gives that message.
Hierarchy in Smartsheet and Jira Connector not working
I don't seem to be able to get any hierarchy to work using the Jira connector. Smartsheet Hierarchy When I first sync'd my smartsheet with Jira all the rows were rearranged and the entire hierarchy in smartsheet was lost. So I figured out I need to use Group by in the Jira connector to respect the Smartsheet hierarchy.…
COLLECT and ISBLANK
Hello community, I have a sheet called Boundary. ColumnA is called "Distance" and has integers . ColumnB is called "distance_to_increment" and has either an integer or a blank field. From another sheet called Summry, I would like to sum, all distances which have a blank field for column B. I struggle with the formula, for…
Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v
I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past. For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future. When viewing the report directly, the report is correctly…
Dynamic View - Delete a View and Change Source
How do I delete a Dynamic View that is no longer required Please? How can I change the source Sheet or Report used to create a Dynamic View, please? Thanks, Si
Looking for a requirement template in Smartsheet
Hello, I am looking for a requirement template, does anyone know of one or has built one already?
Dynamic Views in a Dashboard
I have tried...honest!! I just can't find a way to link a DV to a Dashboard. Any ideas please?
Data uploader
Greetings I am having a problem syncing the Data Uploader with my Smart sheet. As soon as I try logging in using my account, it says internal server error. Has anyone else faced this issue ? Thank you
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.

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