or Explore Discussions

# Formulas

## Discussion List

• Combining Formulas
In Archived 2016 Posts
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…
191 1
Closed 191 views 1 comment Most recent by Travis Archived 2016 Posts
• Combining formulas for child rows
In Archived 2016 Posts
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…
41 3
Closed 41 views 3 comments Most recent by Irene Plant Archived 2016 Posts
• Auto Checkbox Completion
In Archived 2016 Posts
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) …
61 4
Closed 61 views 4 comments Most recent by Leo Plant Archived 2016 Posts
• Formula to show monthly count
In Archived 2016 Posts
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 col…
813 5
Closed 813 views 5 comments Most recent by JamesR Archived 2016 Posts
• Formatting Date in Smartsheet with Month Name Displayed
In Archived 2016 Posts
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 i…
1025 2
Closed 1K views 2 comments Most recent by Travis Archived 2016 Posts
• How to remove slashes from formula that includes date field?
In Archived 2016 Posts
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 020…
11 1
Closed 11 views 1 comment Most recent by Travis Archived 2016 Posts
• When checkbox is checked harvey ball to show as full
In Archived 2016 Posts
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…
41 1
Closed 41 views 1 comment Most recent by Christian Wells Archived 2016 Posts
• Is there a way to access the current time?
In Archived 2015 Posts
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.
471 4
Closed 471 views 4 comments Most recent by Travis Archived 2015 Posts
• Sum values from a column based on whether another column is empty or not
In Archived 2016 Posts
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…
253 2
Closed 253 views 2 comments Most recent by dfo222 Archived 2016 Posts
• Sheet Summary Row, with CountIFS to determine % and Dynamic references
In Archived 2016 Posts
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 summ…
381 8
Closed 381 views 8 comments Most recent by Christian Wells Archived 2016 Posts