-
Formula help required
Hey Team, So here's the situation, I need to report on a dataset, grouped by client name, then by job number: I'm importing a dataset into Smartsheet; filenames should be in the below format: Great. I can run a formula to break this up and run the report. Right? The issue Human error. Some examples of incorrectly named…
-
Formula to Flag Duplicate Values
Hi - I have been trying to create a column formula that will flag duplicate values in my [SKU] column while leaving the first occurrence unflagged. Some of the values in the [SKU] column are either Blank or "TBD" so I would like to ignore those values. My ultimate goal is to be able to filter my report from this source…
-
Formulas and functions for tracking delays
Hello! I would love some guidance on if there are any formulas or functions that are useful for tracking delays with a project. More specifically, our organization is hoping to track who was responsible for the initial and subsequent delays with a project. In our sheet, we have columns for: Task, Assigned To (Dropdown),…
-
Formula To Set Urgency Based On Multiple Criteria (Fields)
Hello, I have a sheet that lists requests, and I want to write a formula for the Urgency field (Critical, High, Medium, Low dropdown options). Estimated End Date Actual End Date Users Affected Work Blocked Users+Blocked Urgency Status 06/19/26 06/12/26 15 No Completed 06/11/26 17 Yes ! Critical In progress 06/15/26 5 Yes…
-
Sheet Summary Formula
Hello- I am trying to get a formula to display a certain cell- Hours Available in Week when the Team Member is Jaclyn and the Week Number is 22. I keep trying the formula below: =INDEX(COLLECT([Hours Available in Week]:[Hours Available in Week], [Team Member]:[Team Member], "Jaclyn Light", [Week Number]:[Week Number], 22),…
-
Automation won’t stamp “Last Changed” date when Status is formula + linked cells
Hello! I’m trying to timestamp when the value changes in a Status column I've created, but the Status column is formula-driven and its inputs are linked cells / cross-sheet references from multiple source sheets. In my Master sheet, the Status column is a formula. The fields that drive that formula are not manually edited…
-
Need to find the whether the task done on time or not with DATE + TIME Functions
3 Teams handle this Deadline, 1 day each. Total Deadline 3 Days. Each day 24 hrs deadline. Ex: Received Date/Time 06/08/26 7 PM to Due Date/ Time 06/11/26 7 PM. ( 7 PM is not fixed irrespective of time, but we need 3 working days as deadline not 7 days - Mon to Fri) 1 Scenario: Team 1 If Received Date/Time has text value…
-
Splitting multiple form answers
I've seen a few workarounds for this, that usually require another party or app. I've also seen "basic" formulas using INDEX, for this, but as someone who is VERY new to Smartsheet, I'm hoping for some additional guidance. I created a form, essentially for class registration. Sometimes people sign up for 1 class, sometimes…
-
Count Blanks from Referenced Sheet
Hi all! I am attempting to count the Blank cells in the 'Assigned to' column of another spreadsheet and have it not include the blank cells at the bottom when the rows are also blank. This is the formula I'm using now, but it is counting those blank cells/rows at the bottom of the reference sheet: =COUNTIFS({Deposit…
-
Formula broken on one sheet but not broken on others?
Hello Smartsheet Community! I have a formula that is acting up on one of our sheets. We use a budget sheet that is standardized across multiple Business Units and one of the sheets is currently throwing an #INVALIDVALUE error with the below formula. =IF([PO or CC]@row = "Purchase Order", SUMIF([Salesforce…