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.

Count a Titled Course if there is text in the cell, but not "OTHER"
Sometimes more than 1 course is taught at the same location. I am being asked to count the number of courses taught, quarterly. On rare occasions, a course is not taught and OTHER is entered in that column. (OTHER could mean initial meetings, graduation, etc.) Here is the existing formula. =IF([COURSE 2]@row = "OTHER", 0,…
Alert for Filling in Cell for First Time?
Is there a way to be alerted when a cell goes from Blank --> not blank? To see when it got edited for the first time? To be alerted when any change is made in that cell doesn't help me.
Using Smartsheet for Secret Santa
Hello, This holiday season I thought what could be better than using SmartSheet for Secret Santa at the office. I was curious if there was a way to randomize names to determine who gets who? or any other fun ideas I could incorporate. Thank you Here is what I'm already doing -Reminder automation emails with fun little…
If/Then Division Formula
I am trying to make a formula where IF the dropdown in row B selected is 50/50, THEN the dollar amount in row A is divided by 2. Does this make sense? Is there a way to formulate this?
INDEX MATCH to OTHER WORKSHEET
Hello, I'm evaluating the use of Forms for a "field ordering" system from an Item Master Table. Best scenario is to create a form to request multiple items via a single submission (not multiple items in a single cell = less desirable data management), and also to have a confirmation submission email sent to an email…
I need the sum of random cells in a row
Here is my formula, and S/S does not like it. = [National Instructor 1 Numerator]@row + [National Instructor 2 Numerator]@row + [National Instructor 3 Numerator]@row + [National Instructor 4 Numerator]@row Am I missing something? I copied this from another community question and she wrote back that it worked, but it's not…
Calendar not working
Wondering if there is a nationwide issue with Calendar scrolling in calendar view. we can not scroll or select a date or even week. seems to be a glitch since last update. How do we escalate this issue?
Saving changes to sheet freezes in all browsers, all users
Hello Community! We are having a major problem with a sheet that our company uses. We've reached out to Smartsheet for help, but the issue is persistent. Information on the sheet: It's used by about 15 employees It has 550 rows and just over 37,400 cells This issue has been consistent for the past month, November 2019 We…
sheet templates
Hi i'd like to find existing template sheet to decline a strategic plan ( hoshin kanri matrix), has somebody already done it
Seeing user activity as an admin
I am an Admin of our account and want to see what smartsheets are owned by each user and the activity on each sheet (date/time). Logs only shows me logons. I need to verify that licensed users are really using the product. I put a ticket into support a week ago but never heard back. Hopefully I can get a response here.…

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