-
CONTAINS with Trigger Search
Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device type that contains "Coin". This address will then be checked against the address column until…
-
Dashboard/ Report "Current User" Not Updating
Seem to have an issue with the Dashboard I just created not updating appropriately. I have a report reading various project information from a sheet. With said report, I have the condition set to filter based on "Current User", which is reading the Project Manager Column (set to Contact List). The issue I'm seeing is if…
-
Creating and maintaining a graph of values from several sheets
I want to graph a specific set of values from a number of project sheets. Each project has it's own sheet and there are certain values associated with the project that I want to show as an aggregate graph. So using "Percent Complete" as my example, for 20 projects I'd like to show a graph of the distribution in terms of…
-
Using Countif in place of Autonumber - formatting question!
I'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request Type]@row, {Ticket Assignment}, 2, false) + (COUNTIFS([Request Type]$1:[Request…
-
Calculate Week number from multiple choice dates column
Hi, We are running a Wellness challenge for a charity. Participants log the days and duration when they performed the activity. We allow selecting multiple dates for the same activity. I try to total Duration for a week. "Duration" mean the number of hours for each of the selected days. First, I need to convert a date into…
-
Report with image of attachments
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to create a report that can show the picture next to the fields associated the punch list item. Another way would be to export…
-
Rich Formatting On "Summary Sheet"
I'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from multiple sheets and can be formatted. I have 20-30 real estate development/construction…
-
Need Help Sorting & Grouping "Day" Data By "Week"
I'm brand new to functions and Smartsheets in general so please bear with me as I attempt to learn with you all. I've read over the functions documentation and to be honest, it's a little over my head. I'm trying to suss out a step by step otherwise I get lost. But I'm hoping I'll get there eventually! Here's the nuts of…
-
2 Reports not showing on my published dashboard
When I publish my dashboard 2 reports are stating they need to be viewed on Smartsheets. the other 3 reports have viewed no problem. They all have the same permissions levels. HTTP s://app.smartsheet.com/b/publish?EQBCT=3c11a22bbcc142df8368f9ac975c1ec4
-
Disregarding N/A in Formula
Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary…
