Community

In our Smartsheet set up, we provide photos of users that appear with their name (in assigned tos, owners, etc). These photos will appear in sheets, reports, etc.

However, when we use a given report or data source in a dashboard, the image/photo is removed. Is this a known issue or is there a

I am looking for a way to only show rows that have data or are non-zero in a bar chart like the pie and donut charts do. I have a list of people with counts for how many rows they have assigned to them on a master sheet. I want to have multiple dashboards (one per manager) that shows the number of

I'm trying to see if a certain column in my Sheet has had any activity in the last month. I know that I can go into each cell and see the history for that cell, but is there any way to create a separate column that states if the "% Complete" column has changed in the last month? I'd like to create a

I modified a template package for Project Management that has a form that enters project requests to a sheet.  A Project Plan Template uses vlookup back to the project request sheet to enter project specific information to the plan. 

Problem:

I need to extend the reference cells every time a line is

I LOVE the work flows!!! But I have 15 facilities and 15 of the same worksheets. Is it possible to:

1. Clone the work flow from one worksheet to another

or

2. print the work flow so i can enter the same verbiage & flow in all the sheets.

While I am here - is it possible to send an Update Request

Hi,

I'd like a formula to calculate the below

SUM the leave days Request(Column Number of Days) against the employee(Name Column) if Approved(Manager Column) and Approved(EXCO Column). If either one of them are not approved then don't SUM the leave days.

This is what i have so far but cant seem to

Dear Community,

I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value.

Here are the formulas I have been trying:

SUMIF($[Payment Status]5:$[Payment Status]50), "Received", [2019 Wk 02]5:[2019 Wk 02]50))

=> result to #UNPARSEABLE

Hey, I have set up a dashboard with a hyperlink to another Smartsheet item (a report). When I click on it the report opens in the same window, which is what I want it to do.

However, when another user clicks on the link it opens a whole new window. This happens regardless of whether the user is

Hi all,

I have currently set up cell linking, however I only want it to cell link once the drop down box has been changed to 'Converted'. As in, we receive a lead and add the data to that lead. Once that lead is 'won' or 'Converted' I change the drop box to show this. Once this is done then I want

I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine:

=IF(AND([Status1]3 = "Low"; [Status2]3