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.

Send alert/notifications including headrow and children rows in the attachment
Hi All, I want to send automated notifications to my employees containing their absence records. To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment. So far I can only do this…
VLOOKUP reference another sheet with parents
We are looking to create a formula to reference a date in another sheet (sheet 2) and than see if the referenced date in (Sheet 2)is before or after the date in the formula sheet (sheet 1). Forcing a check box or adding a visual identifier to the formula if it is true would be ideal. I've created this VLOOKUP formula, but…
Estimated Durations
I ma moving from Microsoft Project to Smartsheet and trying to replicate workflows that have served me well for decades. In Microsoft Project, I can indicate that a duration is a estimate by including a question mark, for example 5d?.I use this heavily as placeholders when building a plan so that I know that I need to get…
Values across different tasks for Dashboard?
Hi, I have a big sheet (called "Test")that have a lot of tasks that have the same type and number of subtasks. All subtasks have an "assigned to" column (contact list) and all subtasks are among three typs: not started, in progress or complete. I created a separate sheet (called Test.metrics) that roll up all "assigned to"…
Workspace to folder
Hello We have created a Project Template Set which is structured in a Workspace. Is there a possibility to quickly change the Workspace template set to a Folder template set? Kind regards, Rdp
duplicates of smartsheet where we ourselves can color our duplicate without making changes in the ma
Hi Can I: Duplicate a smartsheet where we ourselves can color our duplicate smartsheet without making changes in the master smartsheetet? Best regards Jacob
CountIfs- How many of one name in a date range
I have - a column containing start dates, that spans 2019 a column containing an assortment of names that re-occur on a random basis. I want to count how many times each name occurs each month. Any help appreciated!
"COUNT" function with link to another sheet
I'm trying to set a "count" function to count the number of records in a specific column of another sheet, in order to allow a continuous screening of the recordings in that sheet. But the function can't be set as long as the targeted column is still empty. Is there any possibility to overcome that issue? Or even could it…
Requiring Approval when Dates Change
Hello community - I currently have an approval request enabled that notifies me via email once a day whenever a date in the Due Date column is changed. I also have a dashboard that shows me whenever an approval is needed and would like to eliminate the emails coming in to advise me. Is there a way to set up a column that…
countifs formula to sum not blank dates
Hello ~ I'm new to the community and working with the COUNTIFS formula. Help would be much appreciated if you can see the error of my ways. What I want to do seems simple - I have a "Date Completed" column, defined as a Date type, and want to count how many times it's been entered in the column. I saw a thread earlier that…

Popular Tags

Trending in Smartsheet Basics

Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags