-
Employee In Take Form: Trying to auto check selections based on 1 and 2 column criteria.
I have many columns created with a checkbox. Ten columns are labeled as required devices for employee types. [Employee type column named "Role"] When a certain employee type is entered in the "Role" column the "Devices" column check boxes would be auto selected showing what devices are required for that Role. Example: If…
-
Formula to only include status of parent rows and the contact assigned to them
Hi folks, I'm trying to create a COUNTIFS formula that calculates the number of "In Progress", "Issue/At Risk", "Postponed", and "Complete" statuses that a specific contact has (in this case, the user assigned in the "Lifecycle Lead Column"). The problem I'm having is that I only want to count the parent rows, not the…
-
Count formula needed
Trying to do a count formula that compare. So two columns, One called actual and the otheris call budget I want to do a count if Actual is Greater than budget then I want to do another count where Budget is greater than actual Thank you
-
When a row is created, how can I tell one of the columns to add today's date...
So I'm using Unito.io to pull data from DevOps, and I need to know when the row was created ( Not Updated ) in smartsheets. So, I looked at using the "auto number," but there is no way to tell it to use the date. Can someone help?
-
Avg collect Error
Hello Community, I'm running into a bit of an issue. My previous worked fine for the year 2022 but now that we're in 2023 I need to adjust my formula to account for the year change. Below is the formula I had been using which has worked well in 2022. However, now that I'm attempting to collect the avg score from the same…
-
Gantt from JOIN COLLECT Dates
Good day Is it possible to get Gantt functionality to dates we got from JOIN COLLECT formula? Thank you in advance!
-
Unique documentnumbers
Hi, I would like to know if is possible to create unique documentnumbers based on input in coloumns. Or more important the opposite, prevent that a number is used twice. E.g.: Metadata Projectnumber will always be the same, drawingtype 1 will/might be different, drawingtype 2 will/might be different, area code will/might…
-
IF AND formula
Hi Experts, I'm using below function in column "Model count" which works fine, =IF([helper column]@row = MIN(COLLECT([helper column]:[helper column], [Model Number]:[Model Number], @cell = [Model Number]@row)), 1) but I would like to add another check upfront. If (Article dev type)@row is NOT "CO", than it should use the…
-
I want to count how many cells have a date.
I am trying to find a way to count how many cells in my column have a date in it. I use the formula =COUNT([Target Launch Date]6:[Target Launch Date]24) but it always appears the error code #DATE EXPECTED. I tried the same formula on other columns with text and it works perfectly fine. I also tried =COUNTIF([Target Launch…
-
Lost of cell formatting (color, font type) in Alerts someone email
Dear users, I found that the automatically generated table by Smartsheet and incorporated to email (generated as a part of Alert someone automation workflow) for some reason lost the formatting of cell, f.i. if on the original Smartsheet webpage the cell is colored in green and text is bold in email I see regular font and…