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.

Sending customized notification using "Send..."
Dear Community, I'm building a database responsible for customer's inspections, combining internal flow (adding inspection points for project sheets, sending internal reminders about notif. date, changing statuses, etc.) as well as external flow - meaning sending official notifications for customers. I'd like to use…
How to Calculate Dates Between Columns
Hello, I am attempting to calculate days between two column dates within Smartsheet. I used the NETWORKDAYS({column1},{column2}) formula and received the following error message #UNPARSEABLE Screenshots have been attached for your review.
Automated rules for lines do not transfer into reports
Hi Community! I have created a report in Smartsheet that shows me all my open tasks across all sheets. If the date on a sheet is in the past, the corresponding line turns RED. Unfortunately, this is not automatically carried over into the report. Is there a common mistake i made?
Select MAX(Modified Date) where name = Jane Doe
Hi, I have a contact log form that populates a sheet each time a user creates an entry. Each user creates several entries a day. In a separate sheet, I want to report the date that each user created their most recent entry. How would I go about that?
Automation Flow : "when a date is reached" -> not working!
I have tried to modify this automation flow numerous time. The goal is to send every week (ideally; Friday, in the morning) a message to all shared users on a sheet to enter the # of hours spent on a specific topic. I have tried to adjust this workflow multiple times; each time that I wasnt getting notified by email (nb. I…
Import contacts from one Smartsheet to another
Hi, is it possible to import contacts from one central Smartsheet list into another Smartsheet ?
RYGB labeling
Is there a way to label the RYBG dots so that when you choose the color dot a text shows up beside it as well in the same cell? Simple example: Red - Stop; Yellow- Caution; Green - Go; Blue - Sky
Cell Linking Modified Date
I have a main sheet I use to gather information from underlying, linked sheets. Is there a way to get my base sheet to update with modified by date of those underlying sheets? (i.e. I have one sheet I use to roll up information from more detailed project plans that are linked. When those project plans are updated, is there…
Conditional Formatting Grid View v. Calendar View
I am new to SmartSheet. I have a column called "Conference Call." I set a conditional format that appears correctly in the grid view but not in the calendar view. I'd like the word font/color to appear the same in the calendar view that it does in the grid view. I am attaching screen shots.
Project Management - Resource Allocation
Hi, Is there a way when allocating a resource to be able to set what days they work, e.g. On Monday / Tuesday / Wednesday?

Popular Tags

Trending in Smartsheet Basics

How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags