-
How to add an Image into a cell in a Report
We have a single sheet broken into many reports that different users use during a process of development of a product. The sheet holds all the columns and is the single source of truth while the reports give snap shots of each step and only shows columns relevant to that step/user. My question: You can copy/paste an image…
-
Calculating Days
Hello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.
-
Calculate number of days per month within a date range that spans more than one year
I have a schedule that spans (2) calendar years. I want to return the number of days per month included in the range. Since I use this result for billing purposes, I have a column per month and year of the schedule the returns the number of days in that given month/year. I am running into problems once I get to the same…
-
Control Center Global Updates
We are now using Control Center to provision projects and as we are learning how to use it better we need to keep doing some updates to the templates and the existing projects we have already provisioned. I have been using the Global Update feature, but when I use it to update a Dropdown list in a Dropdown column, the…
-
Hidden Fields in Card View
Is there a way to HIDE fields in the card view, just like you can hide columns in a grid view? I have fields hidden in my grid, but when I go into a card view and click into the card ALL the fields are visible. I have set the 9 visible fields when you are looking at the card, but when I click into the card to make edits…
-
Need to count project managers and number of projects
I'm hoping the smartsheet Gods can help me. I'm struggling. I have 126 projects in my sheet and about 30 different project leaders. Each project leader is set up as a contact (see 2nd screentshot - Pink) I'm trying to count projects by project lead. I'm hoping to come up with something like the first screenshot. Any ideas…
-
Count cells with specific values in row with matching ID across sheets
Hi, I have the following requirement: I have 2 sheets, each with the [Project Number] column as the ID. Let´s call the sheets [Intake Sheet] and [Picking List] The [Intake Sheet] holds, for example, a range of 10 columns in which machine part names are entered. Let´s call the columns [Machine part 1] … [Machine part 10]…
-
Manufacturing Production Report
Hello, I work for a relatively small manufacturing company where our production managers meet every single morning, give their production numbers, headcount, etc to the manufacturing managers for them to enter the data manually in excel every morning. We created a form in Smartsheet for the production managers to enter…
-
Need Formula help!
I need a formula that will do the following: When the Date in WKU column has past place the latest NewPromiseDate from the AllPromiseDates column in the cell.
-
Can a range be specified with a beginning and no end?
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…