We use smartsheets to run our customer projects.  The approach we have used to date is to create a workspace for each customer, with the necessary sheets - all from a template.  This works really well, as the customers need to review and contribute to several of the sheets that we use, and the



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:


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


I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is