-
Smartsheet users in The Netherlands
Hello, We're using Smartsheet in our R&D department to manage product development. In order for us to make a next step in using Smartsheet functionality and building more complex dashboards, we are looking for Smartsheet users in The Netherlands or Benelux. Please reach out to me if you are or know someone. Thanks, Rob
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that pops up when I try to convert it to a column formula: I like the current formula because it allows me to set up my Request…
-
How to average the duration between dates if conditions are met
I'm building a spreadsheet with monthly metrics and having issues creating a formula. There will be a separate smartsheet with individual events (1 row per event). The formula I'm trying to build: For all events with a date of notification within X month & year, average duration between 2 dates (start & end date for each…
-
Trying to calculate Service Mileage interval to trigger update request and reset counter
Hello everyone. I'm trying to build a solution to manage our fleet of equipment. One of the things I need to track/manage is mileage and when certain maintenance tasks should be done. We have the task grouped into A (7000 miles), B (14000 mile) and C (40000 miles). Our technicians will be performing a daily check of the…
-
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")