-
Sheet Summary Formula capturing dates before current expiry date column
Hi all, I thought I had this one down but I keep getting an error message. This is a sheet summary formula. Any ideas what I am doing wrong? =COUNTIF([CURRENT EXPIRY]:[CURRENT EXPIRY], >TODAY) Thank you!
-
Count Days Old and highlight
Update: corrected my formula and i have figured it out! Just had a Syntax error :( I am trying to count the number of days old for an item based on the a date field I created, and then highlight that row if it is over 7 days old. I know I can use the conditional formatting based off the days old field, i am struggling to…
-
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…
-
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…