-
Percent Columns in Correspondance with N/A tasks
Hello, I am trying to create a gantt chart for tradeshows that allows you to grey out certain tasks that are not relevant to that show. I have a conditional formatting set to grey out the task and the row if you type "N/A" into the percent column. I am not wanting to delete the task/row, but just make it irrelevant - if…
-
DASHBOARD SHARING
Can we share our dashboard with anyone who does not have smartsheet account and does not need to sign in to see the report dash board? I am making Dashboard that anyone can access it with the link I gave it to them but the problem is it ask users to create the smartsheet account. How can we change that so that we do not…
-
Smartsheet file shorcuts
Hi there, Does anyone know how to pin shortcuts for specific Smartsheet files to Google Chrome? Essentially, I'm after the quickest way (minimum number of clicks) to open specific Smartsheet files. Thanks, Paul
-
symbols - words showing not colour
Hello please can someone help with formatting? I can't understand why the word Grey is showing rather than the symbol? I've selected the set for the 4 colours from the symbol menu for the status column and created the below formula =IF(Status15 = "Complete", "Green", IF(Status15 = "In Progress", "Yellow", IF(Status15 =…
-
Gantt chart timeline settings
I have admin access and have set the Gantt settings on a particular sheet to Primary heading: Months Secondary heading:Weeks I have shared the sheet with another user and given them Editor - can share permissions but they are seeing a different view on the Gantt chart. Why is that? What do I need to do for them to see the…
-
Sum values from column based on criteria
Hello, I am trying to sum values from a reference sheet based on common criteria. However I am running into either "#INCORRECT ARGUMENT SET" or values that are not the exact sum as expected. My idea is to SUM the values from the attached request sheet (column 12), into the corresponding rows (column SUM) in the attached…
-
Use SmartSheet for Resource Planning
Hey There, I am new to smart sheet :) I want to use SmartSheet to... * ... get an overview over all projects that are going on in the team. * ... get an overview about the project status. * ... see how many resources are available (aka how many manhours are available). So far we using simple Excel sheets and oviously I…
-
Countifs with Unique values
Hi, I have a sheet within parent/child rows, and need to count the number of unique contacts within each of the children rows of each parent. I have a vendor column that has a parent row and children row (only the children rows list the vendor contacts). I need to count the number of unique vendor contacts, within a…
-
Primary column not returning values in Report
I am creating a report using data from 5 different sheets. All 5 sheets use the same columns, including a primary column called Project Name. The column has data in on all 5 sheets, however this data is not showing in the report. Interestingly, when I print the report to pdf, I see the project name values.
-
Multiple Upload Fields
Hi, I need to have 2 upload fields on my smartsheet (1 for a logo and the other for photos). Can you please assist in helping me get this built. - Kyra
