-
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…
-
Plotting cost over time
Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin or end in a calendar month, but not for items that span months. I am pretty sure each cost would need to be broken down into…
-
Sharing segments of a Form's responses
I am looking to share only select results of a Form using a Report, but, in order to do so, it appears that I would need to provide access to the initial Form results. Is there a way to avoid doing that so that the person cannot see all of the form's results (i.e. departments other than her own)? The Report doesn't…