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…
Formula - Return month as text from a date cell.
I want to use the formula: =TEXT(*CELL WITH DATE*,"mmmm") But this doesn't seem to be a valid formula on Smartsheet. So if I have a cell with the date "01/01/19" - I want it to show "January" in another cell.
Is the Email Notification highlight color yellow definable?
In a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
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…
Attachments & Proofing
Hello, To proof I have to first upload a file, but what if the file had already been attached to the row; is there a way that an attached file can be automatically moved into proofing. Thanks
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…
Linking two sheets into one master sheet
Ok Here is what I got, I have two employees who work for purchase import section. From Rising the IPO to having the LC created to have the goods delivered to the factory. I have created a common grid header for each of them and they are populating it as I write this. I will then create a master sheet where I will put in…
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]…