-
Is there a way to weight a report based on a value?
We track tasks with smartsheets and we have an effort level column that is meant to help demonstrate (via a report) what workload across a department looks like. We want to be able to create a report that weights projects with a '1 effort level' smaller than a '4 effort level'. Any suggestions on how we could do this?
-
Time Spent /Formula
Hello, I want to calculate the total time spent by each user to then create a graph. I tried a formula but it does not work. Can you help?
-
Collect Multiple Row Data into a Single Cell Reference
Hi Smartsheet Community, I am attempting to create a meeting planning set of sheets, and I am struggling with the following. SITUATION: Provide a formula for referencing a stakeholder register sheet for the name of a meeting attendee, and display their PTO in the cell. Please note that there will be multiple attendees for…
-
Indexing the way to go?
We have a master list, utilizing Smartsheet to build a CRM, that will be completed by form entry or by sheet entry and can be completed by different team members who contact the same business. 1 - looking for ways to report cell history specific to a business filtered by business name 2 - looking for a way to group…
-
How to build a row amortization formula
I have the following fields in smartsheet: Value: 10,000 Remaining Periods: 20 Amortization per Period: 500 I am able to create a row amortization in excel with a formula based on the "Column name", but unsure how to do this in smartsheet since I can't reference column name. Is there a way I can easily recreate this? (see…
-
Cross reference another sheet and filter the criteria
Looking for a formula to pull data from another sheet and add 2 filter criteria. Here is my filter critera but not sure how to reference the source smartsheet. =COUNTIFS([Client Mitigation Status]:[Client Mitigation Status], "Pending") + COUNTIFS(SBG:SBG, "AERO")
-
Clarification regarding Average(collect)?
I'm trying to calculate the average lifespan for a specific machine in a specific area, but am running into an issue with my average(collect) formula. Here's the formula I have right now, and it only returns as unparseable. =AVERAGE(COLLECT({Lifespan},{Machine},"1",{Row},"1",{Position},"1")) In this instance, its to…
-
Workflow for After Hours Tickets
Hi all, I currently manage our support tickets smartsheet and live on east coast. I have a team member who lives on West Coast and I want to create a workflow to have any tickets submitted between the hours of 5pm EST and 8PM EST sent to him with a notification. Currently, I am capturing the date/time ticket is submitted…
-
I think I need an index match formula as source sheet is unsorted
Hi, people smarter than me. I have been trying for days and days to get a formula to work. The source data is not sorted; it is populated by form data. The vloopup formula only duplicated the same result from the first row over again. =IF(VLOOKUP([Primary Column]@row, {2024 Circulation File Num to Support Level}, 1, false)…
-
Percentages lost when indenting linked cells aka best way for roll up smartsheet
Hello I am trying to connect about 50 project plan sheets on one sheet. The requested configuration is a traffic indicator for a customer then the ability to drill down to see each customer project and status then a drill down for high-level milestones. FYI I have just read about the limitations so I understand eventually…