-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Duplicate Flag
I have been using =IF(COUNTIF([Invoice Number]:[Invoice Number], [Invoice Number]@row) > 1, 1, 0) in order to check off a "duplicate" box and then added conditional formatting around that check box to visually assist staff with potential duplicate invoices being entered. It has recently stopped working for some reason and…
-
Using Cross Sheet References with Large Scale sheets
I am using a large scale sheet to host a 23k+ row set of data. I imported the data into a table view. In a separate sheet, I am trying to establish a cross reference with my large scale sheet but I keep getting an error. I was just approved to use the large scale sheet, and I've never used it before. I know it comes with…
-
Approval Flow Using Timesheet Data
Good morning, I'm still fairly new to Smartsheet (2 years) and have an approval automation question. I have a timesheet built in Smartsheet which collects time data from field-based foremen. On occasion, the workers reporting to a foreman have a need to work extra over time beyond what is normally approved. The extra hours…
-
SUMIF from another sheet gets an Incorrect Argument error
I didn't think many options for arguments for SUMIF but apparently, I was wrong! Here's the sheet. My formula - SUMIF({I-DriveLowDate}, "Pre-2000", {I-DriveFiles}). I've swapped the ranges (that often confuses me with SUMIF), and tried the criteria with quotations, without, with @cell, but always get the #Invalid Argument…
-
Best way to automate weekly requests for task owners to add a row comment?
I’m trying to improve how we collect weekly status updates from task owners and would be interested in how others have solved this. Right now, each task has an owner and they type their weekly update into a Notes column. It works, but over time the Notes field becomes a running history and gets pretty unwieldy. What I’d…
-
Chart not including all columns
I created a metrics summary sheet to show averages of a metric by month and by discipline. When I try and use the Chart widget, it will only show one month's worth of data. When I try and use the AI, it doesn't seem to be able to create the graph with the disciplines side by side and is stacking them, showing a total of…
-
Workflow Deactivation and Unexpected Unsubscribe Status
I recently received notifications indicating that two of my automated workflows need to be reactivated. However, when I reviewed both workflows, I noticed a message stating that I had unsubscribed from notifications. I have not unsubscribed from either workflow, so I'm unsure why this is occurring. I am the admin of the…
-
Cross-sheet conditional logic while waiting for dynamic filtering for linked dropdowns
Context Sheet 1 (Budget) contains the budget for a division with multiple teams. Each line item is associated with a specific project/team ([Project Name]). Each project has a Cost Center [CC] number and internal order number [IO] to tie spend back to the specific project at the end of each month (pulled from master list,…
-
Automate the Progress Bar With Multiple Dropdown
Hi, This is our current formula for our progress bar: =IF([Deployment Date]@row = "Cancelled", "", IF([Deployment Date]@row = "", "", IF(OR(COUNTIF([Copy Status]@row:[Code Status]@row, "Delivered"), COUNTIF([Copy Status]@row:[Code Status]@row, "--- N/A ---")) >= 4, "Full", IF(SUM(COUNTIF([Copy Status]@row:[Code…