-
SUM(COLLECT) Stopped working
Hello Community, I have been using this formula for years now =(SUM(COLLECT({5.A Invoice Log ASPR Range GR Amount}, {5.A Invoice Log ASPR PO#}, =[PO#]@row ))) + (SUM(COLLECT({5.B Invoice Log Archive ASPR GR Amount}, {5.B Invoice Log Archive ASPR PO#}, =[PO#]@row ))) Somewhere in the last couple of days though it stopped…
-
IF/OR Formula issue
Hi, I'm trying to pull data from another sheet if the date meets the criteria in one of two columns of 12/20/2025. Should I use an if/or or nested ifs? Here is what I have so far but get the #INCORRECT ARGUMENT SET error. Here's what I have so far. Any idea what I'm doing wrong? =IF(OR(INDEX({cutdate}, MATCH([Job ID]@row ,…
-
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…
-
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…