-
Overall Project Status based on frequency?
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โฆ
-
Importing Dates
I am importing a manufacturer's shipping report into Smartsheet with Data Shuttle. If the product has not shipped, the manufacture has a date of 00/00/0000. When I import the data, I want the date to be blank, if the date equals 00/00/0000. How can I make the cell blank if it the date imported is 00/00/0000 ??
-
Help!
Does anyone have any idea of what barcode font to use when wanting to use numbers, uppercase, and lowercase letters characters on excel. I've tried tons of fonts found online as well as extended fonts but nothing seems to work correctly. Thank You.
-
IF AND COLLECT?
I need help with creating a formula that will collect the value in the [Level] Column with the following criteria: [Area Helper] =1 and [Operational Area] = "Airside" Thank you! - Ron Source Sheet: Destination Sheet:
-
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โฆ
-
Need a formula to return a value by looking a table from another sheet.
I have Source sheet with a list of names. In Target sheet, I will be having a column with other set of names. Need to compare the names in Target sheet with Source sheet and return the value which has same name. However, if the name list in the Target sheet does not match the name list in the Source sheet then "NA" valueโฆ
-
Automated workflow - duplicating a row within a same sheet and then change some cell values
Hello, Here is the purpose of my sheet, it is a task list based on an IT ticketing request system. The new tasks are feed with a form. I also have a dashboard and reports to track tasks per user from this task list. So here is my idea, in order for my team to monitor their productivity, one specific type of task needs toโฆ
-
IF Formula with Nested VLookup
I have employees take a test. They are allowed more than one attempt. The results of each test are recorded on a Smartsheet tracker. I then have a second tracker with each employee name, where I want to pull the result for each of their attempts. I'm getting an INVALID OPERATION error. Here's what I want: If on the Resultsโฆ
-
Calculating Due Date Based on 2 different criterias
Hello! I would like calculate the due date based on the date based on "Date Received" and "Type of Request". I have been doing this manually and it would be great to have some sort of automation by using a formula then that would be fantastic and save so much time. The challenge is creating the formula and I have not beenโฆ
-
Trying to Return an Attendance Date Field For Students From A Completed Course List
Would anyone be able to help complete this formula? =IFERROR(INDEX({Attendance Date Range}, MATCH([Learner Email]@row, {Learner Email Range}, HAS({Course Completed Range 1}, "Fundamentals of Epi", 0))), " ") returns blank , but should have a date completed =IFERROR(INDEX({Attendance Date Range}, MATCH([Learner Email]@row,โฆ