-
How to get a count of every time a name appears on another smartsheet
I have 2 smartsheets: the first one: has a list of names and the name appears multiple time based on the number of certifications that you have. If a user have 5 certifications, the name would appear 5 times. I have a second smartsheet that I need to have the user name and the count of how many times that name appears.…
-
Checking a box on all rows that meet a certain critera.
Hi, I'm in need of a formula that checks a box if the "Current Status" Column on all matching "Lab" "Number" columns that are marked as "Review Complete". For example in the screenshot below I have lab number CD722 in 4 different rows. When each of those row's "Current Status" is marked as "Review Complete" I would like…
-
I need to create a date column based on an order number... help?
I have order numbers in the format DDMMYYYY-##### and sometimes in DMMYYYY-##### that are all populated in the same column. So, order numbers that are similar to 14Apr2023-12345 I have been able to figure out how to populate into a date column, but I have not been able to figure out how to handle it when it is…
-
Schedule update dates
Hi, I'm looking at creating a function that lets the user know when the next review date for a row is, based on the Overall Status (not closed), Last Review Date and Review Frequency columns. If possible I'd like to use Daily, Weekly etc., to make it a better experience for the user, rather than using the number of days…
-
Formula help with multiple IF statements using DATE and WORKDAY
I am trying to calculate the date in a [Due Date] column from the [Date Submitted] based on the [Priority Level]. This is what I have and it is only calculating for the [Priority Level} = Routine. The other cells are blank. =IF([Priority Level]@row = "Routine", WORKDAY([Date Submitted]@row, 5, IF([Priority Level]@row =…
-
Automation for filling hyperlink AND a label to a cell
Hi to all, is there a way to automate filling in a specific hyperlink AND a label to a cell? I want to show "Direct link" in the cell, which is the label for the hyperlink. Adding the hyperlin is easy. But how do you bring in the label information? Thanks, Markus
-
Can the values in a dropdown menu be from a unique list?
I have a column, lets call it [Names]. And another column, [Tests]. Lets say I have 3 rows. In the column [Names], I have the values: Row1: Rick Row2: Cait Row3: Rick In the column [Tests], I have the values: Row1: A Row2: B Row3: C Now Let's say I have another column (A dropdown), is there a way I can do an index formula…
-
"IF" Checkbox function question.
I have several checkboxes in my SS. I would like each check box to represent a cost to be added to a "total cost" field. (i.e. if Checkbox 1 is checked, add $2,750, If Checkbox 2 is checked, add $3,750, etc.). Can someone tell me how to accomplish this? Thank you!
-
Assign duration on dropdown list items and update dates accordingly
Hello All, I am trying to see if it is feasible to add a specific duration (in days) to a respective item in a dropdown list. For example, I have the following dropdown list: 1 - Review feasibility 2 - Design Review 3 - MFG start 4 - Inspection And on each item, I would like to capture the duration as follows: 1 - Review…
-
Equation to Find the Second Matching Value at the Bottom of the List
On a project tracking sheet, I am trying to create a "Previous Name" column that will automatically be updated as the project names change. To do this I've been setting up an automation to copy the line to a new sheet called, "Previous Names", once that lines name is changed. The idea is to then create a equation that will…