-
Need help with an Index/Match using TEXT for Dates
Can someone help me understand how I can correct this formula? It's returning Unparsable. =INDEX({Revenue & Opex | ARRONI Row}, MATCH(TEXT(DATE(YEAR({Revenue & Opex Go Live Date}), MONTH({Revenue & Opex Go Live Date}) + 11, 1), "MM/DD/YYYY"), {Revenue & Opex Date Header}, 0)) The formula is indexing a full row. Matching a…
-
How do I make a form field's visibility dependent on 2 fields?
Hi, I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following: if [CheckboxA] show field 1 if [CheckboxB] show field 2 if [CheckboxA and CheckboxB] show field 3 There is no way to do this within SmartSheet forms. You have to have a helper column in the…
-
How to count if checkbox is checked
Hi, I need to count the total number of items that are in progress that are green but I only need it to count the ones where that criteria is met and a checkbox is not checked. I know the formula below works for counting just those in progress and green but I'm struggling to add the checkbox portion to it.…
-
Max Collect Formula for Dates in 1 row?
I have read other help articles, tried writing with AI and still could use some help in writing a formula for the following scenario. I have three date columns. and want to return the value of the date that is the next date but in the future. if the dates were: 10/1/25, 10/10/25 and 11/1/25 it would return 11/1/25. This…
-
Generate formulas using AI in table view
October, 07, 2025 Table view now supports generating formulas using AI, previously only available in grid view. With this feature, you can quickly create working formulas in the formula panel without needing to master complex functions or syntax. Simply describe what you want the formula to do in plain language, and AI…
-
List of U.S. Federal Holidays in MM/DD/YY Format
I need to add business days to a date, and the guidance I'm finding on this seems very arduous and labor-intensive (and it's taking ChatGPT 10 minutes to come up with a list in the proper format!). What are you all doing to manage U.S. Federal Holidays in your Sheets for calculating business days? There has to be a quicker…
-
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…
-
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…