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.

IF(CONTAINS(OR( Help
Hi, I am trying to get the following to work: I have a Sales Order Column where I have 3 possible entries: A date (Ex: 31Aug2019), a 2DP Order (Ex: 11111-1), and a QC Order (Ex: 11111-1 QC). I have two hidden checkboxes that will give a check if an order is QC or 2DP. For QC, I just have =IF(CONTAINS("QC", [Sales…
Not Receiving Email Alerts for "Changes to New Supplier Setup for Streamline"
My peers setup my profile when I joined Serta Simmons Beddings to get email notification of requests made to add new supplier to Streamline. I am still not receiving the notifications, although my peers are. My profile matches theirs apparently. No one internally can help me resolve. Does anyone have any suggestions? Thank…
Open To Today's Date for Viewer and Editors
The "Open To Today's Date" feature works for the sheet owner/admin, but if the user just has "editing" or "viewing" rights, they are forced to scroll on the x-axis to get to today's date. Is there a way to make the feature also work for all users?
Gantt View - Limit Columns Shown
Hi, I'm trying to limit the columns shown in Gantt View. We have some cells that are reporting info from a link. Sometimes these values are very lengthy. 300 words? The problems is this makes each row very tall in Gantt view, and makes the schedule difficult to read. Hiding these column doesn't help. Is there a way to…
Is there a way to share resource view?
Simply what I said in the topic name. I see that I can create resource views, but there does not appear to be any way to share them without exporting to Excel. Is this correct? Thanks.
Portal/Report that can update based on filter applied
Hi I am trying to create a report/portal whereby i can create a page that can show me information from 2 sheets. We have a recruitment process and I want to be able to show a page which has the following information: * Employee details (pulled from sheet A) * All the positions the person has applied for (pulled from sheet…
Can Approval Forms have addition fields/boxes for them to fill out?
Hi, Approvers were having trouble with adding links and tab names using just the comments box. many times they were looking for boxes to fill out. So I decided to add new fields to the approver's form as per attached but when the approve opens it, he cannot add any data into the fields (link, tab name etc) they are all…
CountIfs based on if a cell in the row is >50 and a specific date
Hi, I am working with two sheets. One sheet has active sales orders, while the other sheet is a summary sheet of the number of things that passed/failed for each day of the month (it pulls from the active sales orders sheets). For a particular day (say Sept 1st), I am trying to see how many sales orders passed. Passed…
Tracking comments on reports?
Can comments on sheets or rows in sheet be pulled into a report? I'd like to see the most recent comments added to a sheet on a report of several sheets.
Notifications using Summary Sheet
If I create an automation workflow to notify all contacts on a sheet, will those listed in the sheet summary be included?

Trending in Smartsheet Basics

Automation: Send to contacts in a cell
I'm building an automation to send a reminder to contacts in a cell but it doesn't let select the cell with a dropdown. Is there a workaround?
What happens to sheet workflows when the creator is deactivated?
We have multiple sheets with automation/alert workflows, and the person who created those workflows has left the company. We need to deactivate her account and reassign her license. Will the workflows she built still run? I believe an admin or sheet owner can edit others' workflows, but if we do nothing, will her workflows…
Browse tap disappear how can I bring it back
Hi there, For one of my folder the browse tab disappears when I click in one of the pages for a particular work spaces, but It does no other work spaces. what can i do so it shows on the page again

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