or Explore Discussions

# Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

## Discussion List

• Work days formula
In Formulas and Functions
Hi,  Is there any way you can advise of a formula where I can set something up that picks a date in a column and I set a specified number of working days which yields the final date. So if I have a cell with a date of 10/09/19 and the wo…
65 6
65 views 6 comments Most recent by Paul Newcome
• Mandatory text to activate checkbox
In Formulas and Functions
I have a "Notes" column that requires text before the checkbox under "Req Attn" will be checked, kicking off conditional formatting in other columns.   I found this thread and tried to implement the suggested solution…
37 8
37 views 8 comments Most recent by Andrée Starå
In Formulas and Functions
Hi, I am trying to count live tasks that are overdue but I am getting #INVALID DATA TYPE This is the formula I am using =COUNTIFS(Status:Status, <>"Complete", [End to End Due Date]:[End to End Due Date], <=TODAY()) A…
481 9
481 views 9 comments Most recent by Paul Newcome
• Multiple IF Statement based on Multiple Criteria
In Formulas and Functions
I am currently working on automating an "Assigned To" column based on postal codes. There are multiple postal codes options per individual with three individuals. Is there a way to create a (albeit very long) formula to populate?…
Accepted
209 5
• IF, AND, OR Formulas
In Formulas and Functions
Using my data set, I would like to know by region the number of multi-year reporters and new reporters (2018). I will count either status as an active reporters.  Ex. Africa= total 2 active reporters -Ghana: Multi-Year Reporter -South A…
2 1
2 views 1 comment Most recent by Paul Newcome
• Summary Task status - automatic
In Formulas and Functions
Hello, Im very new to smartsheet, so, im sorry if this question is too "basic".   I have a summary task with 3 or 4 children tasks. I would like to know if there is any way to automatically update the status of the summary ta…
208 3
208 views 3 comments Most recent by Paul Newcome
• IF or IF AND Formula conditions DATE
In Formulas and Functions
Dear, I appreciate your help. I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019) 1) If the Balance column is equal to 0 …
220 19
220 views 19 comments Most recent by Gerardo_Clarke
• Identify duplicate dates and exclude blank cells
In Formulas and Functions
I am working with a SmartSheet that is used by multiple people to schedule meetings.  I am trying to check for duplicate meeting dates within two columns "Proposed Date" and "Proposed End (if multiple days are needed)".…
297 1
297 views 1 comment Most recent by Sean Morgan
• How Nested IF can I get?
In Formulas and Functions
I have a desire to change a Status column based on whether (or not) certain separate (other) columns are populated with a date.  Is this supposed to work?  All of the Nested IF examples I have seen tend to look at just a single column to e…
23 9
23 views 9 comments Most recent by khankoff
• Index or Vlookup or What?
In Formulas and Functions
Hey All! I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am wanting to pull data from the Budget …
163 3
163 views 3 comments Most recent by Andrée Starå