-
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…
-
Smartsheet Outlook plugin/add on
Hi, one of our users is trying to use Smartsheet for Outlook plugin/add on and is always asking for Admin approval to use it. How do I grant consent for my users to use the Smartsheet for Outlook plugin. We are using M365 email service.
-
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…
-
Question about error code 4000
Hello Smartsheet Api support team, I've been developing python scripts on Azure function and they've been working without any issues until recently. I keeping got some generic error when attempting to add or update rows. I repeatedly got the error code 4000. {"result": {"code": 4000, "errorCode": 4000, "message": "An…
-
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…
-
Can @mention Notifications in Dynamic View Link to the View Instead of the Sheet?
Hi all, I’m using Smartsheet Dynamic View to manage access for users who aren’t shared to the underlying sheet. When I @mention someone in a comment within Dynamic View , they receive a notification — but the link in that notification takes them to the sheet, not the Dynamic View. This creates confusion, especially for…
-
Undelete and Permissions
Hello, I am in desperate need of help! The AI is not helping so I hope there is some really smart people out there who can!! PROBLEM I mistakenly deleted the 4 primary sheets I have created and use daily. I tried to undelete the sheets and it is now telling me I do not have permissions. I was the admin, requested the…
-
Merged: longer sheet names
This discussion has been merged.
-
Merged: Provide option to remove popup windows
This discussion has been merged.