-
Combining formulas for child rows
I have an easy formula to work out the average data entered into my child rows, the formula is as follows: =AVG(CHILDREN()), this gives me the average of all data put into the child rows perfectly. However, if nothing is entered into these child rows the parent row with the formula in it just shows #DIVIDE BY ZERO. I would…
-
Auto Checkbox Completion
Hi All, I am trying to get a formula to work that checks a box based on a column with percentage. I.e when 100% is reached the box is checked. I have tried the following to no avail =IF([Compliance]5 = "100%", 1, 0) Similarly I would like to have another column ticked if non compliant i.e <100% again I have tried…
-
Formula to show monthly count
Hi, I am trying to figure out a formula that tells me how many entries have been entered for a particular month. I have a date column and an tonnage column so if I have 10tonne of material made on 1st February i would enter in the date column 01/02/16 and next to it in the tonnage column I would enter 10. I also have a…
-
Formatting Date in Smartsheet with Month Name Displayed
When using the column type of "DATE" the only way dates are always displayed as numeric values. However, some of my colleagues are requesting that the dates be displayed as Feb 12, 2016 or 12 Feb 2016, etc. Is this possible in Smartsheet? The only preferences I have located are the user preferences where you localize your…
-
How to remove slashes from formula that includes date field?
I am using a formula to concatenate several fields, one of which is a date field which contains forward slashes (e.g. 02/09/16). Is it possible to modify the formula so that it removes the slashes from the end result and appears as 020916?
-
When checkbox is checked harvey ball to show as full
I am trying to set up a formula using a checkbox and a harvey ball. Basically I would like the harvey ball to show as full when the checkbox is checked. The checkbox column is titled complete, once this is checked the harvey ball should be full. I have tried lots of different formulas and none of them are working the way I…
-
Is there a way to access the current time?
The function TODAY() returns the date but not the time component. I need more granularity, like a timestamp. The autonumber column types "Created" and "Modified" both provide such a timestamp.
-
Sum values from a column based on whether another column is empty or not
I'm trying to to sum values from the 'Value' column for a particular 'Reference number., but only if a third column ('Confirmation number') has a value. The actual value in the third column is not relevant, just whether it's been completed (confirmed) or not. I've got as far as this =SUMIFS(Value:Value, [Reference…
-
Sheet Summary Row, with CountIFS to determine % and Dynamic references
Hi all, Seeking Smartsheet Experts....! I have a Company Register with columns to identify documents and expiry dates. e.g. [A] Company Name, [B] License (Checkbox), [C] License Expiry (Date) 1) I want to calculate the summary of a count of All companies that do not have a license? 2) I want to calculate the summary of a…
-
Entire Row Reference in Formula
Is there a way to reference an entire row in a formula? I'm trying to count check boxes across an entire row, but don't want to re-write my formula if I add a column. Thank you!