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 clic…
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 havin…
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 st…
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 hav…
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 …
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, …
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 number…
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? ✓✫↔…