-
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…
-
My entire sheet is showing Invalid Argument Set
Hi! I'm pretty new to Smartsheet so I have no idea what I did or how to fix it. BUT we're using it as in invitation platform for an event we run. On my Registration sheet, it pulls data from the Data Intake Sheet. The Data Intake Sheet had an extra column called Travel Group that the Registration sheet did not have. This…
-
INDEX COLLECT MIN (again)
Had a follow up question to my previous question located here. — I was using the original sheets, which I fixed with the solution from that thread, as a template. Today, I copied them over to essentially create the same system for a different LOB. I checked the box that updated all formulas to the new references. Now, in…
-
Perpetual dates
I have a formula that will give me a date. However, when the date is < then today, I want to add lets say 80 days or reference another cell. My formula keeps giving me an error and I tried chat GPT, but no dice. Any help would be appreciated 💖🥹 This is my base formula to give me the initial date: This formula is located in…
-
Sumifs formula application questions
I'd like to apply for sumifs formula in sheet, but seems the function cannot capture the correct sum amount, details as following: Expectation：sum up total service fee from legal entity: 137 with quarter: Q1, and I list the sumifs function as below： The result from the above formula comes up as 55527.49 while the correct…
-
Average Collect formula
Hi, I have a question regarding a formula: We want to get an average result from few columns: First will be the Scoring (Score) Second will be the employee name (Name) Third is the check type we did (Check Type) Fourth is the month (Month) Formula that we used: =AVG(COLLECT({Score}, {Name}, [Name]@row ), {Check Type},…
-
Sumifs formula shows wrong value
Hi., I have two sheets: one is the Master Sheet, where multiple people enter and update their status, and the other is a Report Sheet, which summarizes the data using a SUMIFS formula. I’ve been using this setup and formula for about two years without any issues. However, for the past two days, the summary sheet has been…
-
Broken formula - linking cells from one SS to another - help!
Hi. Someone on my team mistakenly broke a formula that linked a column called "Construction End Date" between 2 SSs. Source sheet name: De Novo SS Pipeline Source sheet column name: Construction End Date When a Construction End Date is typed in here, it should auto-populate a sheet named De Novo (New Builds). Target column…
-
Conditional formatting for a due date that is 6 months or older
I need to create a conditional formatting that will gray out the due date for anything that is 6 months or older. I can't figure this one out.
-
Need help with IF statement that will return
I am new with Smartsheet but am tasked with creating a formula that will return a sum under certain conditions. If the Cost UoM is EACH I need to just return the value in Cost Per Unit, If not EACH then I need to return Nom. Output Cap. * Cost Per Unit. Thanks in advice everyone.
-
Extracting a Date from String of Text
I need help extracting a date from a string of text. I tested each component (year, month, day) separate and get the right result. However, when I put the extraction formulas together in a DATE formula (in a Date column type) I get INVALID DATA TYPE. Sample text string: 2025-10-20T23:26:16+03:00 Formulas that work…