-
Formula to include new data added to my sheet
I have set up a formula that works very well however it isn't taking into account new entries added to my sheet. For example my formula is on Row 1 under the column 'total' I then have other information in rows 2-15 so therefore my formula on Row 1 starts from row 16 to give me the total I want into Row 1. My formula in…
-
Combining Formulas
I am currently using 2 columns to identify tasks "Due in Next 2 Days" and "Past Due/No Schedule". I have been trying to nest the two formulas together to get the status in the same column. How can the following formulas be combined togateher: =IF(AND(Due6 <= TODAY() + 2, NOT(Due6 < TODAY()), NOT(Status6 = "Completed")),…
-
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…
