-
Convert Text to Number?
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…
-
Row auto-deletes contents after a few seconds when I click on it
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
-
Time Logger - Cell History
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
-
Process automation with cell linking ?
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…
-
Feature Request: Rank order macro
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…
-
Fill-down formula, while preserving formatting
Can this be done? How. Thank You.
-
Sharing Worksheet- Removing a person
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.
-
today() function
I would like to conditionally format date columns based on whether something is past due of not. Can I automate that in smartsheets?
-
Contacts - name and company as ID
I am using Samrtsheet where I invite many participants to view or edit the sheets. Often I also have man y different users (contacts) that should be assigned to a task. The problem occurs when I have contacts with the same name e.g. John Johnson. It would be very beneficial to have a Company or another ID to deferenciate…
-
Need to Receive Out of Office Replies for Update Requests
I created a Smartsheet to collaborate with a department that is in another facility. The nature of our collaboration can be time-sensitive, and when someone is out of the office we need to know. The process that currently exists is to use email, so we get the automatic notification. However, when I tested this with a…
