-
Copying Date columns and making them editable from reports
Hi, Back again with what I hope is a simple fix. Background - I am creating a global project tracker, used to manage and maintain over 2k current projects and ~100 new/ intake projects on a monthly basis. Requirement - The intake form feeding the SmartSheet is asking for a Start Date (intake), Launch Date (intake) and…
-
Formula Challenge
Hi Smarties, I am trying to get this formula right in the Formula Challenge from Smartsheet. I am not sure what I did wrong so hoping fellow Smarties could help! In the Parent Row symbols column, write a formula that returns the most common value of its children. If there are equal or more reds than yellows or greens, the…
-
IF Condition issue
Hi, Can someone help me why i am just getting the value as Quarter if i change the value to less than 25 in column =IF([1.1 Landscape]1 > 0.0025, "Quarter", IF([1.1 Landscape]1 > 0.005, "Half", IF([1.1 Landscape]1 > 0.0075, "Three Quarter", IF([1.1 Landscape]1 > 0.001, "Full", "Empty")))) THanks
-
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…