-
Reminder Date Column
I want to take a smart sheet and have a reminder date column. East task that I have I want it to calculate off the duration to give me a reminder to do the task. Ex: Send pricing → Nov 1 of the year before the class Send brochure → 6 months before class date Check website for class → 90 days before class date Check in for…
-
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…
-
Sort a Join/Collect formula?
In a sheet, I have a helper column that concatenates the date and budget columns. Then a field in the sheet summary that uses JOIN COLLECT to list that data. Is there a way that I can have that listed data be sorted by date? In case this helps, here are some screen shots - Helper column Output of the Join - collect formula…
-
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…
-
Conditional Formatting Based on Min & Max Columns
I have a sheet that shows the stock of all promotional items across several locations and I'm trying to set up conditional formatting to highlight the cell if it's less than or equal to the min amount. I can do this manually for every row but wondering if there's a way to do this similar to how excel & Google sheets have…
-
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…
-
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…