-
Metrics in capturing SUM per Monthly
Hi Everyone, We are aiming to create a new metric and visualization that will allow us to automatically calculate the total numbers of FTE per month. Based on the sample data set below, the calculation will go like this: February 2021 -> 110 + 200 + 200 = 510 March 2021 -> 20 = 20 April 2021 -> 120 + 4 + 4 = 128 May…
-
Automatically Select Contact With Column Formula
Hi, I am fairly new to smartsheet so I apologize if this is a basic question. I am trying to automatically populate a contact column with a single contact indefinitely. For context, it's just so that in a separate report that pulls from many sheets, a filter that only allows a row assigned to a contact to be shown can be…
-
Conditional Logic - Setting a Value
Hi - I know a few months back Conditional Logic was added to the Forms which is awesome. I was wondering if there's anyway (that I'm not seeing) where I can use a Dropdown, Radio Button, etc. - to set the value of a Status field. In other words, If Someone Selects Option A from the drop-down, then Status 1 is set, Else,…
-
Updating checkbox using a formula
Hi, I need to update the "Done (Tick to pull into deployment schedule)" checkbox when the "Deployed Y/N" equals Y, any ideas on a formula? Thanks
-
How to have a date dynamically changed based on a value in another column?
I'd like to be able to have the dates in a column update based on the Sprint number. So, I've created a new sheet with one column with the Sprint # and a column for the associated dates. I have a column in my main project spreadsheet titled Sprint #. I'm having trouble figuring out how to tie it all together. I've been…
-
Filter a report by users email?
Hi everyone, I have set up each PM in our company to receive an individual report based on who is listed in the "PM" column in engineering sheets filled out by each engineer. The report for each PM combines the multiple sheets. I am concerned after doing a couple tests because smartsheets contact management seems to be…
-
Changing an older cell based on criteria from a newer cell
Hello, Looking for a little assistance with a formula (or workflow), if even at all possible. I have a row of data with a Date, a Room and a Status of “Conditional Pass”. When that same Room gets checked again at a later Date, has a Status of “Pass” and a new row is added, is it possible to change the original Status entry…
-
How can I display the last value from a column into certain cell?
Hi guys, I would like to display the last value from the column "Project Phase" into a cell (in this case I would like to implement it at the first cell of the column " Project Phase". Regarding to the screenshot, this would mean that I would like to have the text "Offer Phase" to be displayed automatically in my cell at…
-
Counting instances in each of the last 6 months on a rolling basis
Hello, I'm trying to count the number of times a type of dispute occurs within a month in the last 6 months in order to monitor trends. I want the months to roll so I don't need to adjust the formulas ever. My formula doesn't take the previous year into account and I'm not sure how to introduce it. This is what my…
-
How to write below formula in smartsheet
Hi . Can anyone help how to write below formula in Smartsheet