This discussion has been merged.
Hi, I have a sheet with about 500 rows, with a lot of hierarchy (indents) within it. My ultimate goal is to be able to sort rows by one of my columns, and not have the indents alter how the rows are arranged after this sorting. Therefore I planned to create a new sheet where I removed all the hierarchy/indents (sort of…
I provision all projects for our PMO and each project is housed in a Workspace to control access, so, I am the 'owner' for each project in our organization... This setup worked for a time, but now that we're scaling up, I'm receiving access requests for projects almost hourly. Unfortunately, the way we have our project…
I would like to embed a countdown for Go-Live into my project dashboard. Any idea?
Has any one here done an integration with ConnectWise? We have a small company whose resources all work production support and project tickets. If I had a way to feed tickets from CW in so that I could display all open tasks for one person that would be great. Thanks, Jacque
I recently contacted support about this and was amazed to find that what I thought would be a simple function doesn't exist. We have had staff leave recently and not so recently and have had requests from senior management to look for data that they may have stored in sheets that they may of owned or shared or transferred…
I am using the following formula to identify duplicate invoice #s in a spreadsheet. I've noticed that the formula does not work when the invoice # starts with a zero. It works for all other formats: text, numbers (without leading zeroes), dates. The column property is set to text/number. What could be the issue??…
In a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
Our Senior VP is having an issue with a sheet where she is unable to indent a row to be a child/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut. The keys are working just fine (able to CTRL + C/V, and the [ and ] keys all work individually) but it does not allow…
I am looking at ways I can automate export a smartsheet to excel at regular frequencies. I tried using MS Flow, but the Smartsheet connector doesn't have an option to get to get the content. Any ideas?