-
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…
-
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…
-
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…
-
Row ID / Row link
I'm building simple asset tracking system with Smartsheet and would like to have the row links as QR-codes that would then be printed as asset tags. I have not been able to find a feasible solution for pulling the row links for each asset (row). Doing manual copy paste for >2000 rows is not very convenient. I have a column…
-
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…
-
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…
-
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…