Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Offset Columns Issue
Has anyone else had this problem before? If so what's the solution?
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
Decimal Point Issue
Hi All, When entering a simple Children Sum which includes a text string to sum numbers in the column below. For example ="Capex Total: £" + SUM([PO Total]3:[PO Total]113) I'm finding that the numbers after the decimal point either show only one number or lots of numbers depending upon the number of cells the formula has…
✓ ✖ ➜ easily inserting symbols?
In SmSh, it is great we can use symbols in the text cells, and also in formulas like =IF(FIGURE7 < 20, "☺", "♛") But could we get an "Ω" button to make it quicker than copy-paste from google docs? ✓✫↔↗♂♛金☺✔✖☑☌✉∅♪♫
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
Secondary Formula in an OR Cell
Is it possible to have a sub formula be part of the main formula for an IF/OR cell? Basically what I am trying to do is write a formula that looks at Column A and if it is one of two answers from a drop down list report the percentage of the value of Column B, and if the value of Column A is a third value return 0. The…
Can you return a blank cell in a formula that isn't text?
Is it possible to return a blank cell which is then part of a formula that adds up with other cells to result in a monetary value? =IF(MILEAGE6 > 50, (MILEAGE6 - 50) * [MILEAGE EXPENSE]$2) I want values between 0 and 50 to return a blank and not a 0. When I do the above, it messes up the total column because it thinks the…
Formulas not following over
When I input a claim from the web form, it appears somewhat down in my sheet, and no formulas. This is also the case when I have a row with formulas, then I move it to another sheet with the same columns and formulas, but it appears in the subsequent sheet in the bottom row, but no formulas. This is very frustrating…
Attachments and Outlook
Many of my attachments are emails in Outlook. Is there a way to drag a .msg directly from Outlook into Smartsheet?
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…
