I am trying to open a specific report one of my teammates built that allows me to pull data from multiple Smartsheets. When I open the report, I get an error that the Smartsheet. com team has been notified. I checked in with my teammate that built the report and she said it is working fine on her end. Thanks for any help…
This has come up a few times (okay, probably quite often!) as to whether there will be a development for the search function to be able to return results for "close match" vs exact spelling. For instance, we were looking for an entry where the last name erroneously had an "s" added to the end. We were looking for the…
Is there a way in a Smartsheet column to convert a Text value into a Numeric value? For example, I have a column called "Duration", formatted as a "Text/Number" column type, and I have values in that column that are in the HH:MM:SS format, and look something like this: 00:15:00, 01:20:00, etc. I'm trying to add a few of…
Hi, Whenever I click on a row it auto-deletes its contents after a few seconds and "asks" me to type in new content. This is incredibly annoying and I haven't been able to figure out a way to prevent this from happening - can anyone help? Thanks, Seb
Is it possible to show time spent on a particular project? The data is already there within the cell history - it just need to be extracted somehow. The below data tells me the task has been "in progress" for 1 minute - 21.06 - 21.07
We have developed a master process sheet that starts when a client signs a design contract and is completed when the build project is completed. It is rather long at about 250 tasks! and take between 6-12 to complete. We serve approximately 20 clients at a time in various stages. We are operating each client out a copied…
We recently migrated from a google doc to smartsheet for tracking a project portfolio. Google docs offered the ability to apply a Rank Order macro to let us sort the list based on a calcuated priority score for each project in the list. Here is an example of the macro: =rank(AQ3,AQ:AQ) Smartsheets lets us score projects…
Can this be done? How. Thank You.
I copied an worksheet to create a new worksheet that I am working on. Since this worksheet was copied the old owner is still a owner on my worksheet. I would like to remove the old owner from seeing my new worksheet. There is two owners on the worksheet. How do I remove the old owner from the worksheet.
I would like to conditionally format date columns based on whether something is past due of not. Can I automate that in smartsheets?