-
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.
-
Ich habe eine Business Lizenz und möchte Berichte für Mitarbeiter freigeben.
Hallo. Ich bin noch nicht lange hier bei Smartsheet und habe einige Probleme zu verstehen, wie ich Mitarbeiter für von mir erstellte Bereiche oder Berichte zum Bearbeiten oder Betrachten freigeben kann, ohne kosten zu produzieren. Ich habe diverse Berichte für Kollegen als "Bearbeiter - kann nicht freigeben" freigegeben.…
-
Change Cell Workflow across sheets
I know that some of this can be achieved with linking and some manipulative formula but I think it would be great (at least for me ;-)) if there was the ability to change the content of a cell on one sheet from an automation on another. My scenario: I use a date/time based automation to copy pertinent cells from one of my…