-
Troubleshooting Sheet Summary "INVALID DATA TYPE"
Hoping that the community can explain this issue I cannot solve (nor can AI). Today we added a Y2026 Savings column to our sheet. Column formulas were all updated as well to look for values with "effective dates" in their corresponding years. Sheet Summary (for Dashboard) formulas broke returning "INVALID DATA TYPE". Tried…
-
SUM Calculation
This calculation worked before I added an additional value (Alignment Ops Goal Value). The row I have outlined is computing to "1"… not "2" which would include the updated formula with additional Alignment Ops Goal Value. Any help on why this new column isn't being calculated? Its just a simple calculation and I am…
-
1 or more months automatic fill into different columns
I want to put a date in columns that are monthly increments off an entered date field. We want to have reminders when a site needs to be reviewed for warranty items. This is based off 'Planted Date'. I created 12 columns for each month we need to visit the site. I was able to enter the following formula and it works till…
-
Why are my durations not calculating correctly, and how can I adjust this?
I'm working through a rather complicated column formula and ran into something that seems to be native to SmartSheet. It appears to be rather minor, but is throwing the whole thing off for me. If you look at the first row that has dates in it, for example, you'll see that the row starts on the 1st and lasts 10 working…
-
Is Store # present in list?
I have a survey that is to be completed by a set # of store locations (896 locations). I have a formula that will check the worksheet containing the survey inputs for store #. If Store # is absent then checkbox is checked. I want to built a lookup such that if you enter a Store # the result will either be; 'Survey has been…
-
How do add columns in smartsheets dynamically based on a condition ?
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
-
New Function - "PREDECESSORS"
"PREDECESSORS" = similar to current "SUCCESSORS" function but returns the row references for predecessor tasks in dependency enabled project sheets. The values returned should be referenceable values in other formulas, e.g. omitting the SS/FS/FF task constraints in the dependency column so index/match formulas can be…
-
Merged: Toggle for hover over pop-up formula information
This discussion has been merged.
-
How do I check an entire column for a particular value and only display the lowest example of it?
The question title is kind of confusing, so here's what I'm looking to find out. I'm making a Project Plan sheet, and want to have a place that updates the estimated completion date based on how the project has progressed thus far. There are more columns in my sheet, but my question is only related to the ones in the…
-
Receiving an Error Code when Creating Chart
Hi everyone! I created a metrics table to count how many "Critical, Major, Lesser" observations I have per a CRO Management group for a specific timeframe (quarterly). The formula I used in the metrics sheet is as follows: =SUM(COLLECT({Audit Schedule Range 6}, {Audit Schedule Range 2}, "CRO Blood and Marrow Transplant",…