-
Multi column evaluation to set RAG type status
Hello everyone, I'm beating my head against the wall at this point trying to figure out how to make this work. I have a project tracker - each row is an over view for a given project. In my case I have 8 columns for status that are all set to High, Medium, Low (cued RAG but not balls - conditional formatting for the color…
-
AIA Forms
We use an AIA form process for the pay applications in our industry. I am wondering if anyone else has been able to implement an AIA form in a sheet?
-
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…
-
Next working day calculation
Context: I've a Smartsheet that, given an agile software release number in the form of Year.Week.SubVer that calculates the release date based upon the first Monday of the Year (SubVer = Day of week, 1=Monday, 2=Tuesday), so 2015.18.1 = 4/27/2015 (and 2015.18.2 = 4/28/2015 etc) What I'd like to do is be able to somehow…
-
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…
