-
today() function
I want to create a formula tht creates a Datestamp of when a checkbox is clicked. If I use the today() function the date will keep going up. Is there a way to lock a date to the day a checkbox is clicked? Thanks, Shaun
-
Web Forms using Hidden Fields with Formulas
I currently have a formula on a hidden field on a webform. When that web form is submitted, the formula is imported into the sheet with an apostrophe before the formula which creates an issue of having to manually adjust the formula after each web form submission. Can this be remedied? -Brenton
-
Preserve leading 0's:
-
Is there a way to use cell references in an IF() statement?
I know you can use cell references in the "logical_test" clause but is there a way to use them in the "value_if_true" and "value_if_false" clauses? Al the examples of IF() statements have just text strings for what the IF() statement resolves to. I'd like it to resolve to the value in another cell. For example:…
-
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? ✓✫↔↗♂♛金☺✔✖☑☌✉∅♪♫
