
Hi,
Do we have Date and Time format now for Date columns?
Formulas and Functions6
Benjo09

I am sure this is rather obvious, however I am not seeing where my mistake is. All I am trying to do is return the average cost of a product cost column but I need to not include any $0.00 dollar amounts that are populating (which will hap…
Formulas and Functions9
Deanna Vandermeer

Hi Smart Community,
I am trying to Sum my CHILDREN() Countif but it is not giving any value. All my subchildren is indicated as flag (1 or 0)
Example
When there is a delay release in a category Bug Fix : it will flagged out RED. On Bug Fi…
Formulas and Functions9
Syed Mohd Muhafzal

I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the ima…
Formulas and Functions166
caroline_allen37286

Hey all,
I'm relatively new to Smartsheets and am hoping someone can help me out. I promise I've looked everywhere for an answer and I think I'm making this more complicated than it is. Thanks in advance for the guidance!
I have a sheet …
Formulas and Functions16
A. Marcus

Hi All,
I am trying to do calculate a total number of events, that match criteria for 1. Date range (can also use fiscal column as a matching criteria where i only want those that contain specific letter/numerical value = Q2) for all ND…
Formulas and Functions10
Mona Singh

I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected.
For example: I have a single …
Formulas and Functions11
Eric Glassey

Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most basic of the formulas out of this. Bel…
Using Smartsheet30
[email protected]

Hi everyone,
I need to use INDEX MATCH formula to get a DS# with a CNDT# in another report.
The easy formula would be: =INDEX({DS Report Range 2}, MATCH([CNDT Number]1, {DS Report Range 3}, 0)), "") but the thing is that sometim…
Formulas and Functions21
Jose Rivera

I currently having issues with creating formula that gets the average of 4 cells that have the option of 4 different symbols (Red,Yellow,Green,Blue). The goal is to show the average of the four cell symbol's in one here is what I have so …
Formulas and Functions12
joe.quinones

Hi
Within my project plan sheets I have 2 columns , On Time/Late and RAG.
On Time / Late Column Formula
=IFERROR(IF(AND([Original vs Current (days diff)]@row > 8,
[email protected] = "Complete",
[email protected] = "true"), &q…
Formulas and Functions10
Lindsay Wilson

Hi,
I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are …
Formulas and Functions9
Carolina Rivera

Hi All! I am using a =Count(Distinct({Range})) which works exactly as expected with one range of data, but returns a "1" with the exact same formula on an adjacent column of data. The only difference between the data in the 2 c…
Formulas and Functions30
Brian_Vaughan

I have a table that sometimes has duplicate entries in a column. I'm doing a VLOOKUP on this column, however, obviously, if there is more than one match, this generates an error.
What I'd like to do is return a match for the most recent d…
Formulas and Functions39
Dennis Wierzbicki

Hi,
I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula below but all I get in return…
Formulas and Functions12
Carolina Rivera

Hi,
I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month, I want the counter to return "5". I've been trying to use the formula below but all I get in return is a…
Formulas and Functions14
Carolina Rivera

Hello! I am trying to calculate the amount of times a cell dropdown is changed per day. Is this even possible or would it need some magic workaround?
In any given day the "current stage" column changes possibly many times. An exa…
Formulas and Functions12
Cassie Hart

I am writing a simple COUNTIFS formula and I am getting a very different answer when I created a column reference vs. referencing a specific range within the column. What am I missing? I am trying to count the number of customers that ar…
Formulas and Functions11
JHand

Hi!
I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14
However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both co…
Formulas and Functions14
Carolina Rivera

I need help on a formula for Project Assignment when a dollar amount is what determines who gets a Project assignment.
For example,
A Facilities coordinator will get a project if it falls between $5k  $24,999
Project Manager A will get…
Formulas and Functions24
Linda F

=IF(AND(% Complete]3 < 1,[End Date]3 < TODAY()), "On Time", IF(AND([% Complete]3 < 1,[End Date]3 = TODAY()), "Due", IF(AND([% Complete]3 < 1,[End Date]3 > TODAY()), "Past Due","Complete&quo…
Formulas and Functions13
Danielle D'Alessandro

I'm trying to create a formula that counts the number of entries submitted to a separate sheet per person completed since a specific date (3/24/2020).
My formula that works for counting all entries by individual is =COUNTIF({Other Sheet R…
Formulas and Functions10
[email protected] Seattle

I'm looking to add some formula to my summary sheet and the requirement is for analytics for Last month, last quarter and last year  so excluding current month
Examples if:
current month = May 2020
last month = April 2020
last quarter =…
Formulas and Functions32
SueinSpain

I have a sheet with some formulas.
If I add a new row of data ,the formulas are autofilled as expected.
If I add another row of data, the formulas are not autofilled.
If I save the sheet after adding the first row of data, the next new row…
Formulas and Functions16
Joachim Mund

Hello!
I am tracking assignments and a person can have more than one assignment. I need to be able to count the number of persons assigned on the sheet but don't want to count dupes. The fields are "First Name" and "Last…
Formulas and Functions30
jgneely72151

Hi all,
I hope you're well and safe!
I've developed a solution that lets you store the date or value.
You'd use the copyrow automation and a VLOOKUP or combination of INDEX/MATCH to make it work.
We'd trigger the copyrow to another sh…
Formulas and Functions25
Andrée Starå

Hello!
I am in need of help writing a formula to autocalculate the "% Complete" column based on the "Start" column date and "Finish" column date. Additionally, I also have an auto column for "Duration&qu…
Formulas and Functions13
Anthony Soyak

I have a master sheet that may have duplicated column data, like:
Client Name  Status (dropdown)  Delivery Date  Feature (checkbox)
Client A …
Formulas and Functions59
Kevin Segrist

I've a field for ClientName. I would very much like for subtasks to automatically inherit the Parent Card ClientName value. How might I do this? My users prefer using the Card view. They feel that if they have to use the spreadsheet view, …
Formulas and Functions385
hbaseler

Have an issue I thought I had resolved, but ...
I have a sheet that has two relevant data ranges:
Range 1 = a single column that specifies a Content Type for each row item. There are 7 possible Content Types: Data Sheet, Ordering Guide, B…
Formulas and Functions14
Danielle Arteaga