-
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ā¦
-
Error - Formulas reference too many cells
I have an automation (copy row to sheet B) that is failing. My error is attached. I investigate Sheet B, which is a large sheet, many complicated formulas, but my total count of cross sheet references is only 14. Does this mean there is a limit for the amount of intra-sheet cell references? If so, what is the limit, howā¦
-
Formula to change date from existing date column to the current year?
I have setup an automation to send a Microsoft Teams message to a channel whenever it's someone's birthday - and the only way I was able to do this was by taking the birthdays in the "Date" column and making the year this year versus the actual year the team member was born (if not, I wouldn't be able to set up a "whenā¦
-
Ideas/workarounds for how to look up multiple values into multiple rows?
Hi Smartsheet Wizards. Bear with me, as I'm not sure about the best way to ask this questionā¦! I have a "look up" sheet with thousands of contacts/email addresses and organization ID numbers. I need to pull out all of the contacts for a specific set of organization ID numbers. I have this set of ID numbers in anotherā¦
-
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ā¦
-
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ā¦
-
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ā¦