-
Workspace Management: restrict creation
In an effort to manage our teams and to keep their projects grouped together, we have individual workspaces for each department. We want these users to have a license so they can create and manage their projects accordingly; however, we do not want them to have the ability to create ad hoc workspaces that our PMO or…
-
Smartsheet Automation Problem
Here is a very simple automation which says that if a row is added or changed, and the value of Status is blank or 'On Hold', then change it to 'Backlog'. Now i add two rows, first has status blank, and second has status 'On Hold'. The automation changes the value of second row and not the first. Anyone has an idea why? Is…
-
Sorting Dropdown Columns
I feel like at some point, sorting a dropdown column ignored the column properties. This was nice because I could add and remove options as needed, but when I sorted my rows based on this column, they would sort properly. Now when sorting a dropdown column, it is based on the column properties. Now we have to manually sort…
-
Some APIs not working?
Some of the APIs inexplicably don't seem to be working. For instance, I can make a request to the Get sheet endpoint fine, but when I try to List columns with the exact same variables I get a 404 Not Found response (see attached screenshots). Have encountered this with several other endpoints (for instance, Attach file or…
-
Viewing Last Updated in Sheet
Hello! Is there a way for me to track user interactions in sheets? I have found how to see last updated by. But am I able to get more specific with this? See when a sheet was last viewed? And when updated am I able to track what was changed at a cell level? Thanks!
-
Modify Sheet Summary field
Currently have a field in my sheet summary with this formula: =COUNTIFS(Finish:Finish, <=TODAY(+14), Finish:Finish, >=TODAY(), [Helper Parent Column]:[Helper Parent Column], <>"", Status:Status, <>"Complete") I would like to add if the Status is "Not Needed". How do I modify the formula?
-
How can I get this formula to work
Hi, I still have a lot to learn in Smartsheet, but I have been using co-pilot to assist. However, I need help with this formula that I cannot get to work. My goal is to strip the site names off any special characters expect for the first four letters# and "offnet. I'll appreciate the any assistance that can be provided to…
-
Collaborative and real-time editing
If multiple users end up editing the same cell without realizing, the last change that was saved overwrites the other. All editors should be able to view the current cell that is being edited and should be able to lock them as they continue to edit.
-
Conditional formatting broken in table view?
I set up 3 CF rules across 3 columns. Above 60 is supposed to be green, between 30-59 is orange, and below 30 is red. I see no orange, AVG FPS column is not formatted and working at all, and some random columns aren't formatted. I also do not see "equal to or greater than" and "equal to or less than" as an option. What's…
-
audio/mp3 preview in Smartsheet proofs
The image and video previews in proofs are awesome, and such a timesaver. However, being unable to preview audio files is a royal pain to have to download each one just to preview it. The simple ability to preview audio files within proofs would be very welcome.