I need to add up the following: 

1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 

2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). 

Currently using:


I'd like to allocate non-working days for individuals tasked with deliverables on my project plan. I have two Smartsheets:

  1. Sheet 1 = A project plan - showing all allocated resources against multiple deliverables.
  2. Sheet 2 = A Vacation Planner - showing all team members involved in the project and the


So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page.  Do the Viewers also need access to the sheet the report is pulled


What types, if any, of external input from other programs is SmartSheet capable of handling/using?

IE, is there a way to set up a sheet so that whenever a certain program updates its information your sheet does as well?  If so, what types of programs function in this way with SmartSheet?  Is it


I've noticed that some of the dates entered, if too far in the future will revert to last century.

i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50

Also, once you enter the date as 01/05/2050 and it is shortened to


Hi there!

I am hoping that Smartsheet will prove to be the solution I am looking for, but I need a bit of help to get set up correctly.

I currently manage a Design team in a tech org, and I resource two types projects with my group:

- Long ongoing projects (these typically have one to two people