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.

IF ERROR Help
Hi all, I am trying to create a formula where I am getting an invalid data error message when dates are not populated. Below is the beginning of my formula: =NETWORKDAYS([Phase Start Date]44, [Phase End Date]48) I am trying to add a 0 if there is an error, however I'm missing something in the formula: =NETWORKDAYS([Phase…
Help getting started
I am very new to smartsheet and am only day 3 of using the tool. I am looking for some guidance or confirmation in my approach to manage the projects of my team. I have about 53 team members and everyone has anywhere from 5-30 projects that are either being actively working on or are in the pipeline. I am looking for the…
Invalid Operation formula question
The following formula is pulling an #INVALID OPERATION error when a date is entered into the Date Received column - anyone have an idea of what the error is? The column date is set to Date. Thanks in advance! =IF([Date Received]11 = 0, IF($[Q3 Estimated Completion Date]$8 > [Q3 Estimated Completion Date]11, "Late &…
Possible to edit background colour in Calendar View?
Hi All. Here is my use case: we are using Smartsheet as our activity planning calendar for a team of dozen people. We have focus periods lasting from few weeks up to one month. We would like to communicate that e.g. May 1 to May 23 is time for Focus Area#1, and from May 24 to June 16 for Focus Area #2, and so on. Is there…
Conditional formatting for parent/child Kanban cards
I have three parent sections and each has a few children. I'd like to have the conditional formatting of the task bar be different so if something is under Parent 1, it's got an orange card etc. I can't find a way to do that so it's automatic for all new rows added under a parent and would hate to add a repetitive column.…
Comments exporting
Hello. When i export a sheet from smartsheet where there is also comments been added, this appears on a separate tab on the csv file which is exported. Is there any way of being able to link these comments to the main tab so that i can view on one sheet with the comments all on the same sheet?
Having an issue with the "filter" option in Smartsheet
I am in one of my Smartsheet that clearly has a filter applied. However I can't locate the "dismiss filters" option. It seems to have disappeared. My workaround is that I changed the existing filter to select all of my data which allows me to see my entire worksheet. However, I can't dismiss the filter entirely. Please see…
New version of Smart Sheet
Do you know when exactly in April new version of Smart Sheet will be released? I was trying to find any information about that, but in vain. Is there any doc specifying what has been changed and what functionalities would be added ?
copy and paste with death spiral
I'm doing a copy and paste from excel into smartsheet which I've done numerous times. I'm getting the death spinning circle with "Pasting from Clipboard"
Reminders delivered on specific time i.e. 3 30 pm
Can someone tell how to set up reminders for specific time 330pm 4th April, not just date like 4th April

Popular Tags

Trending in Smartsheet Basics

Dashboard Metric Widget Not Updating with Current Backend Sheet Value
Hi all, This is from a sheet that uses a formula to count down / display the number of days til end of Quarter. What is happening: Displays 37 when the backend sheet actually says 34. The dashboard does not update until I click to open the backend sheet then the connection seems to go through to update the…
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…
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags