-
Counting specific names in a table from a specific drop down menu
Hello everyone, I am trying to create a cell that calculates the number of times a certain name shows up whenever a criteria is chosen from a dropdown menu. Currently, I have Column E with a dropdown menu of names (uses data from Column L). Column F will use that cell as a reference to populate a cell using VLOOKUP…
-
Month Function Sorting in Report
Hello! I have a sheet that captures items and their start/end dates in a date format. I am trying to create a report that will group the items by the Month that the item is taking place in chronological order (Ex: All items with the target end date in January would be grouped under "January", followed by all items with the…
-
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
-
Help with High Priority Function
Hi! I am relatively new to Smartsheet and trying to figure out how to program a sheet I am working on. I have one sheet holding many rows, each row representing a different project. For each project, the user is able to mark the priority as high, medium, or low, using the built in Smartsheet symbols. The goal is to make it…
-
WorkApps roles in control center
I need a suggestion or a workaround. I have more than 20 contacts for Recon Approver for multiple selection per cell, and the Smartsheet limit is 20. I want to add all the contacts so that when I create a new project in Control Center, all the contacts will be able to see the project(s). Is there another way to accomplish…
-
Resturant management
Is anyone using Smartsheet to run a restaurant financial management? And other related topics I am thinking to utilize smartsheet for cost management, revenue, inventory, assets management. Any thoughts where to start? I have a background in using Smartsheet to develop templates and use reports to form numerical…
-
Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
-
Conditional Formatting Query
All the above rules are working except the 4th one in the list which asks for the cell to turn red if Group status is not started and end date is in next 14 days. I have used the Smartsheet AI tool but no luck, I have saved and refreshed. I am using a helper column for my 5th rule in the list which asks the cell to turn…
-
Set Task Duration from Formula
I have a project with many repeated subtasks, and sub-sub tasks. To generalize: Task A has Subtasks 1, 2, 3 Each subtask 1, 2, 3 has sub-sub-tasks a, b, c I would like to describe the duration for Subtask 1 with a, b, c in a general set at the bottom of the sheet. Can I link the duration of Subtask 1, 2, and 3 to the…
-
Planned vs actual progress (Summary level)
Hi everyone, I am trying to calculate the % Planed based on the start and finished dates but when I try to set the Complete (actual) progress just to verify that all of my plan y on date, I see that the summary tasks are not calculated correctly. I am using the following formula =ROUND(IF(TODAY() < [Baseline Start]@row ,…