-
Duplicate
Hello, I was able to find a formula that works to ignore blank cells and identify duplicates but the first entry is also being labeled a duplicate. Is there a way to ignore the first entry and only add duplicate to all proceeding? =IF(AND([Column Name]@row <> "", COUNTIFS([Column Name]:[Column Name], [Column Name]@row) >…
-
Can anyone fix these countifs and sumif functions.
Hello. I am trying to make a dashboard with 2 charts. one that shows how many projects each project manager is accountable for, as well as whether they are type A, B or C. the other shows the income from each project manager's projects, as well as whether they are type A, B or C. to do this I have made matrixes where I…
-
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…
-
Collect hour and date - Task completed
Hi, Is there a way to have a column who collect automatically date and hour when an another column has a check box check?
-
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,…
-
Moving From Airtable to Smartsheet - "Link to" equivalent?
Hello community - long time listener, first time caller. We're considering a move from Airtable to Smartsheet and looking at how to migrate some of our more complex tables. We have several tables that use the "Link To" field type, which allows you to select one or more values from another table. Essentially, you identify…
-
Conditional Formula with Symbol (Red, Green, Yellow) Dependent on Column Answers
Hello, keep getting unparseable when use formula to get color coded symbols for responses on 4 other cells. Symbols Wanting to Use Color Dependent on Answer of Other Cells in Row Red=filed, yellow=submitted, green=approved Example of formula: =IF(([EHS Reviewer 1: Approved or Filed]@row=Approved,"green",[EHS Reviewer 1:…
-
Return a Blank in an Index Formula
I'm using an Index formula, =INDEX({T3DP V4 - Project Schedule Range 2}, MATCH([Release Version]@row, {T3DP V4 - Project Schedule Range 1}, 0), "") and want to return a blank response if there is no value in the [Release Version]@row. I keep getting a "#INVALID DATA TYPE" message. Thank you, Kim
-
Conditional Formattng for Dates in the Future
Hello, I'm trying to figure out a way to set up conditional formatting to highlight a row when 30 days have passed since the event has been scheduled. I have set up an automation for the date to be added when our team changes the status to "Complete". I'd like to highlight the entire column blue 30 days after the scheduled…
