Hi, 

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

Hello! I am looking for ways to display Resource Views to users who do not have licenses. Right now our licenses are reserved to Project Managers, so our Leadership do not have a license. We want to be able to display the resource view to our leadership. We do not want excel based...but would like

Hi everyone

Is it possible to set the time off (holiday, edit) at the resource level and have it reflected in the project plan?

Thanks, in advance, for any guidance.

Hi all,

I currently generate a weekly resource allocation view across all project sheets using the built-in resource reporting** (exporting to excel, importing to Smartsheet...) 

This is useful as it provide a single link with a comprehensive view that can be sorted by resource/project/role/manager

Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or

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