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.

Finding 'send' history form a row
Hi - Is there a way to see what was sent when using the function "Send" when selecting a specific row? I see the activity log notes some information, but I don't see this anywhere. Am I missing it? Is it a better practice to always CC myself to keep track of what I am sending? Thanks! SarahB
Do Dashboards on IOS update automatically ever?
Wondering If it is possible to make a dashboard on ios update every minute like how you can do on a desktop? Or, is the only way to update it by hitting the refresh button?
Index/Match Returns No Match but vLookUp works?
I have an index/match formula that is returning a No Match and when I try the Vlookup it is working. =INDEX({BE Job Intake Range 1}, MATCH([Project ID]@row, {BE Job Intake Range 2}), 0) The colunm in the lookup table is a formula result combining the values of two fields. Seems to work fine when I use the vloopup but not…
Google reCAPTCHA is disabled in Settings. However, CAPTCHA is still requested while submitting form.
The Google reCAPTCHA image is disabled in the settings for our Smartsheet form. However, while trying to submit the form - have multiple image captcha being asked for. Our team has cases in which, the image is being asked for 3-4 for times most of the times, and has gone upto 6-7 times in some instances. Is anyone else…
Formula Date Not Syncing With Conditional Formatting
Hi, I'm trying to automate my start date and due date columns. In order to do this, I'm essentially hard coding the month and day piece of the function (e.g. "01/01") and then extracting the annual piece of the function from the Task column (e.g. "2024" to "24"). The output, I believe, is similar as it would be in excel…
How do users of a source sheet access the Calendar I've created?
Hello! I've created a calendar in the calendar app based on a single source sheet. When I go into the sharing settings of that calendar it gives me this message: Users with access to the source sheet or report already have access to this calendar. However, other users (with admin permissions on the source sheet) do not see…
Using COUNTIFS referencing to another smartsheet
Hello, can I please request for some tips/advise on the Computation Sheet that Im working on. So this Computation Sheet is just a summary of data that I have extracted from my main sheet (titled MMR Quality Report). So the target is to extract the total number of External and Internal for the month of July. Can someone…
Dashboard metric widgets display is not same for data pulled from same sheet
I'm trying to figure out why the font size of the numbers are not the same for all the metrics widgets. They all pull from the same portfolio metrics sheet (shown below). Is there a way to adjust font size so On Hold and # Completed values (2, 3) are the same size as the other metrics. Appreciate your help!
What size image, width x height, is best for a background logo on a form?
Has anyone discovered the right dimensions for an image to best fill a form background? Is it conditional on form-factor? dm
Portfolio Template with Capacity Waterline Help
I'm thinking of transitioning my current project portfolio to this template that includes a capacity waterline but I'm having trouble getting started. Usually the templates include a guide on where to start and how the data flows between the sheets, reports, and dashboards but I can't find it for this one. Thanks in…

Trending in Smartsheet Basics

How do you update an existing users email address due to a last name change?
Hello, I'm a system admin and I've run into something new and I haven't been successful in finding an answer to. I have an existing user who recently got married and changed her last name. Her email address has been updated in our systems to reflect the name change. Example: Jane.Doe@company.com to Jane.Smith@company.com I…
how can I search for a sheet and exclude certain workspaces in the search?
how can I search for a sheet and exclude certain workspaces in the search?
Restrictions on "Clear Cells" automation?
I want to set up a rule to have a cell contents cleared when the completed date is filled in another cell. I have used similar automation in the past, but when I try this time is does not give me the column of the cell I want to clear as an option to choose when setting up the rule. Are there restrictions on the cell type…

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

Watch video

Smartsheet Basics

Categories

Popular Tags

Smartsheet Basics

Discussion List

Categories

Popular Tags