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.

How To Remove Empty Fields from Smartsheet Email
I am working on creating a smartsheet form for Supply Ordering for my organization. Is there a way to have any empty fields from the email I get when a report has been submitted? There are 80 potential fields they can fill, but all 80 are never filled on the orders. Each site orders different quantities and items each…
Moved: How to Delete all rows in Smartsheet using Proc Https
This discussion has been moved.
Moved: An unexpected error has occurred
This discussion has been moved.
Would it be possible to copy rows to another sheet on a specific day of the week
If I was to use an =today() in a column to grab the current date and then a condition using the IF(WEEKDAY(Date@Row) = 1, and make an automation for say, every Monday (1), could I copy a row (or rows) to another sheet when that day condition gets triggered? I will try this as I think it should work…..but I am fairly new so…
Inconsistent Formatting in Dynamic View
I have added colors to columns, but it seems to inconsistently format in the Dynamic View as seen in this screenshot. Does anyone have any advice or feedback? Thanks, Jeanna Wright
Form submission limit?
Is there a way to limit the number of submissions that are made by a certain person on a form?
Average value between two dates.
Hi, I have generated a report from different project sheets. I have a column (C) which has dates when a particular task is completed. Column D calculates the time taken to complete that task (Turn Around Time - TAT). I want to calculate the average TAT taken to complete a task in the month of Feb. I am not able to put two…
Summary Function Between Business and Pro
Apologies if this is the wrong area to post this… I am a one-person shop that uses Smartsheet to manage various tasks. One of these is the PTA where I volunteer as a board member. I would love to use the dashboard feature to track certain metrics (parent attendance at events and our performance in fundraising) and show…
Postmortem Templates
One of my coworkers asked how to utilize a postmortem template he found through a Google search. It is on the website, but I can't find it listed in Templates when I search directly in Smartsheet. It also looks like no other template I've seen in Smartsheet before, and the article it came from is dated in 2020. Has anyone…
Examples for Custom Welcome Page and Custom Help Page
I have read the help articles for enterprise customers on how to work with branding, and I understand, that I can add an URL with a customized welcome page and Help Page. However, I am very interested in seeing examples of good /best practice of such customized pages - may I see yours?

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