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.

Use same column type and values on multiple columns
I have 150 columns that will have the exact same column type and values (drop down list with the exact same values). How can I apply those rules to all the columns without having to open each one individually and manually applying the formatting? Thanks
Using Contact Lists within a Form
Can we use a contact list within a Form and allow multiple individuals to be selected like when working within the sheet itself?
Symbols not showing in reports
I have a large Smartsheet grid that contains important information against a list of devices. Some of this information shows the status of some testing and is displayed as symbols. Rather than share the whole sheet with staff, I would rather share a selected few columns in a report. However, symbols & dropdowns do not…
Send an update request to a contact in a contacts column on the 1st and 7th of the month
When setting a recurring update request directly from the row, you cannot direct it to send to the person in the contacts column and when you set an automated action you cannot set a frequency based on the day of the month.
How to represent the Gantt chart on a Dashboard?
Hello There, We have a project plan and would like represent them on a Dashboard. How we should proceed ?
Removing Multiple Link
I have created and tested a few examples of the master sheet where it links data from two base sheets. The bases sheets are maintained by my team and I don't require any changes. I have successfully done so but due to me testing a few times, the bases sheets are showing, each cell, data is outbound linked to <unknown…
Using a checkbox to countif
I am trying to count based on 2 criteria if checkbox is checked. So far it only returns a zero value when the checkbox is checked. Here is what I have... =COUNTIFS({Real-Steel Estimator Review Total Loss Tes Range 1}, "true", {Real-Steel Estimator Review Total Loss Tes Range 2}, Appraiser5, {Real-Steel Estimator Review…
Formula for Duplicates
I am looking for a formula that does not count the duplicates so that it can count unchecked boxes. Does anyone know of one?
Formula Auto populate
Hi, I am facing a challenge..when I submit a new form the formula is not auto populated in that row..Please advice. moreever, I am using a IF error formula this does not show blank like its does in Excel IFERROR(IF(VLOOKUP([ES_Code]1, {Lookup Sheet Range 1}, 7, 0) = [Audit fees are denominated in this currency]1, "Yes",…
Resource Management
Hi there, we have this issue in few smartsheet pages where assignment is not working properly. we assigned a person %10 (or any other percentages) to the work and no matter what we do, it shows %100.

Popular Tags

Trending in Smartsheet Basics

I am new to smartsheets!
I am using Smartsheets to gather data and send out mass messages. How do I send out sheets to a mass group without just texting out the link? Is there a easy way to send out forms via SMS and Email? I need a Smartsheet mentor!
Restricting dropdown options on forms but permitting on backend for editors
I have a form with a question that has three restricted dropdown values. I only want 2 of those values to show on the form but on the sheet it populates to, I want a third restricted option available for a user with access to the sheet to edit.
Deleting something in a Report also deletes it in the Sheet?
I have created a number of reports from a set of surveys, and just realized when I deleted an unnecessary row from a Report that it deleted the same information from the related Sheet. Everything I have read says that Reports are just representations of the Sheets, so why are deletions of cells and rows in my Reports also…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags