-
COUNTIFS Formula help in sheet summary
Hi, I currently have one field in my sheet summary which calculates the current project week. I also have one which calculates the number of tasks in the current week with the below formula, linking a column to my summary field showing the week number tasks are completed: =COUNTIFS([Projected Week Work…
-
Setting formula to match dropdown list in columns (same row, same sheet)
Hello, I need help please. Is there a way to set-up a formula so that an item in a column with dropdown list will automatically select an item in another column with a dropdown list? For example, Column A has 1,2,3 in dropdown and Column B has 4,5,6 in its dropdown list. If 1 is selected in Column A, it will automatically…
-
Control Center - Global Update Find/Replace Formula
Hi, I am testing the functionality of the Global Update feature in Control Center using the Starter Project data. Since not all my projects will have budget information available and entered in the Request Intake sheet this will generate an error on the budge variance calculation. What I would like to do is update the…
-
Best way to grab rows from a column and add their value to a list or dictionary in Python?
There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the column to a dictionary?
-
Need to extract Non-duplicate values
Hi, I'm in the need of extracting the Non-duplicate values in a range. I could able to achieve same in the excel (Formula =UNIQUE(A2:A16)). See the attached excel schreenshot. I knew Distinct function is a replacement of unique in smartsheet but it can be used within the other function and not working propery. Kindly…
-
Status Formula based on Date Range
Hello - I need help with a formula for a status column based on a date range (start and end columns). Status options for the formula include: Not started, Live, Completed For example, is the item has a date range from 2/21/23 to 2/28/23, the status should automatically change to "Live." If the dates in the date range are…
-
How to show most frequent status per unique groupings?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Simple CountIf
I was looking for a simple COUNTIF formula to search the entire column and only count the cells that have a value. It can be any value. Does anyone happen to know of a formula that would work for me?
-
How to return a cell from another sheet when the criteria is within a text string in the source?
I'm trying to pull the notes from a Request sheet into the Review sheet, but I'm only getting results when the search criteria (Contract #) is the only contract in the cell in the Request sheet. Ex 1: Line 1 in the source, "123" in the Contract #, has "Urgent" in Notes; the current formula returns the correct notes into…
-
How to get specific data from a list on sheet with most recent or higher level of issue?
So, I have a raw data sheet that shows each time an employee receives a type of correction within the organization. I need to somehow extract both the most recent and highest level they currently have based on only certain policies, and I have no idea how to build any formula to pull this needed information, here is an…
