-
SUMIFS/COUNTIFS Function: Total values but filtering out particular Status' AND Dates (Years)
Hi All, Firstly, I'll be honest and say I'm unsure whether this is a COUNTIFS or SUMIFS function but leaning towards the SUMIFS function based on my understanding of it. I'm trying to run a report to show the numner of (Column: Status) Closed Won and Closed Lost opportunities and the (Column name: Value) total value of…
-
Set a row to 'not applicable'
Hi. My project contains 3 sheets to represent network areas and includes the site locations within the networks. The project tasks are the same and include deployment stage gates and user adoption stage gates. We would like to use the same set of stage gates across all of the network areas for consistency and reporting,…
-
How do you extract numbers out of a cell and create a chart with the data
How do you extract numbers out of a cell that is formatted in a 12-hour clock and paste the numbers into another cell? I need the column "Time Duration" to know the difference between the "Start Time" and "End Time" and then on possible another sheet show a chart of over a period of time. I was even thinking, I could…
-
COUNTIF Query
Hi All, I'm trying to run a query to group and count certain status' in order to count them as a single statistic. For example: If there's 4 'New / Reported' tickets and the 'Pending External Clariication' has 5 tickets, the OPEN tickets box would show 9 OPEN tickets. Ticket classes: Open ticket = The status' (New /…
-
report: take over colors in grid view of a project
Hello, her's my build. I have a project file (file 1) with all details of different project but always with the same structure with different colors. Out of that I created a second PM file (file 2) with links to that main Project file (file 1). --> Until now all fine thanks to the "link from other cell of sheet" this has…
-
Reporting on who and how many times an individual has attended events
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all the data about who is attending our events is in multiple sheets. Using email…
-
Report as a daily reminder.
Hi, I have strange problem. Becouse my coworkers would like to have a report sent daily in the morning. So they can see what tasks (from few sheets) they are assigned to. I already've made those reports and tried to "send as attachment" but it doesen't work (don't know why it isn't sending pdf's like I made it on a…
-
Bug/Error? Report widget on dashboard doesn't link to specific row
I created a report that includes the "Sheet Name" column. The auto-generated links in this column go directly to the specific row on the sheet it's linking to. However, when I add the report as a widget on a dashboard, the links open up the sheet but they don't go to the specific rows. Seems like a bug/error. This happens…
-
Calculating a minimum payment figure using a formula or function
Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my finances in order and thought I'd use Smartsheet to plan this. I've done a screen shot…
-
Link Data in a Smartsheet on a Specific Day and Make Static
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links data from the %Complete metric on a given day, and make that data static in the new…
