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.

Emails -------
Is there anyway to modify the body of the email. I would like to like dates in smartsheet to a "date" in the body of the email. Hello, Your company is now "live". Follow up will occur on 10/31/18 <---- this is the date I would like to have updated when the email is sent out.
Is there a way to auto-fill across the header?
Hi there, Is there a way to auto-fill across the header? For example, if I put the very first date and then add a formula to add 7 days across until the end of the project? Or do you have to manually enter each header? I am trying to find an easier way to update template headers. Thanks, Jill
Hyperlinking Templates
Is there any way to hyperlink a template from a Smartsheet?
IF Multiple Conditions
Hi I m having difficulties in implementing a multiple conditions formula Context: 2 key columns: - Column status with the following available list : COMPLETED / ONGOING / NOT STARTED/LATE - Column Completion: If have created the following formula below to automatically update the Status Column of the Parent line.…
Rollup percentage in project schedule template is not calculating correctly
I'm using the project template in smartsheet, in grid view. I've broken my project up in several phases, each phase a parent with child tasks. The Project % complete is coming out as 99% complete, but it is far from being that complete. Is there something I have to do to get this to calculate correctly, or do I have to…
Linking cells to a child cell in another worksheet
I have created a Summary Worksheet to capture high-level milestones from a collection of project plans. The way I set up the summary tracker is to create a parent-child relationship under each project and am trying to link the start and end dates from the original project plan to this summary worksheet. The challenge I am…
create a project portal with a MS project file
Can you create a project portal with a MS project file (MPP), and update the portal as you update the project file?
CountIfs and Find logic-Can I use together to get pending task counts for a particular Person
I want to count Total number of Pending Task, Completed Task, Not Started for each of my team members from a different sheet (Master Daily Tasks Update-IT Dev Range) to a new sheet Currently I am using this one to count total number of Pending Task: =COUNTIFS({Master Daily Tasks Update-IT Dev Range 3}, "Harry Porter",…
Outlook desktop Add-in doesn't work with shared mail boxes
Hello, I have installed the add-in for Outlook desktop but the Smartsheet button in the ribbon only appears on on my User email mail box - when I switch to our shared mail box folder it disappears. This is a big problem as all our incoming orders are addressed to the shared mail box. It works fine across all mailboxes on…
Formula needs to be removed from Published reports
The formula is appearing on a particular sheet published report. This reappears after refreshing and saving the sheet. Please help :)

Popular Tags

Trending in Smartsheet Basics

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
how can i set up an automation that triggers when a form is submitted?

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags