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.

hid shared contacts from email
the submit request/approval email show at the bottom the emails of other members that share the same email I want to hide that , any suggestions ?
branding our emails
Always the sender and subject email's lines show sent via smartsheet Also it mention smartsheet in the email's body can we avoid this to ease our emails to our clients and self-brand our messages? with my respect this is like you force us to advertise smartsheet with paid accounts its one of things in smartsheet makes us…
adding new users as a group
I need to add over 100 new users and do not want to have to go back afterwards and assign them to a group. Is there any way to create a group first and include them as a group before adding them to the account?
Row Sort
I used to be able to sort my rows now it is greyed out when I try to select the sort function. Unsure how to get it going again? Also is there a way to have the sort happen automatically in the sheet?
Count Cells That Have Dates Older Than XX Days
I tried a few different formulas for this, but pretty much I have a cell on a separate Data sheet that I want to keep a running count of "Open Work Orders Older Than 0 Days" I tried this (IT Tickets Range 4 is the column with the dates in it) and it keeps giving me "0" for an answer =COUNTIFS({IT Tickets Range 4}, TODAY()…
Root Cause Analysis Templates
Good morning, Does anyone have a RCA template that they would be willing to share?
Count number of specific characters in a string
Hi! I'm trying to write a formula that will give me the level of an item in a Work Breakdown Structure (WBS). The formula needs to read the number of decimals in a string. For example: * 1 = 1 * 2.12 = 2 * 3.1.14 = 3 * 2.1.1.1 = 4 * 2.327.1 = 3 The FIND function seems to be heading down the right track (by selecting the…
Alert email to send row attachments attached to the email
Is there a way of sending a row attachment attached to the email, rather than in a link, when using automatic alerts?
Government Utility Projects and Asset Records
Hello Smartsheet Community, I work for the City of Minneapolis, in Minnesota, and I’m looking to reach out to see who is working for governments (local, county, state, or federal) while incorporating Smartsheet into their utility project management processes. Smartsheet is restricted from its privacy policy to release any…
Release announcements?
I got the popup window in the app this morning announcing the new interface but I had to close it right away because I was showing my screen in a meeting. Now I've come to the website and I can't find a single announcement, blog post, or anything that gives detail about using the new feature. Why would you launch a release…

Popular Tags

Trending in Smartsheet Basics

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags