Smartsheet Formulas (Formulas Smartsheet) – Q&A

Smartsheet Formulas (Formulas Smartsheet) – Q&A

YEARDAY Function Correct Ans - Returns a number representing
the day in the year, 1-365, where 1 is the first day of the year
Sample Usage
YEARDAY([Due Date]5)
Syntax
YEARDAY( date )
date
— The date from which you want to return the day as a number

YEAR Function Correct Ans - Returns the year from a date as a
four-digit number
Sample Usage
YEAR([Due Date]5)
Syntax
YEAR( date )
date
— The date from which you want to return the year.

WORKDAY Function Correct Ans - Used in a Date column to return
a date from a specified number of working days.
Sample Usage
WORKDAY([Due Date]1, 30, [Due Date]2:[Due Date]3)
Syntax
WORKDAY( date num_days [ holidays ])
date
— The date to begin counting from
num_days
— The number of working days before (negative number) or after (positive
number) the date
holidays
—[optional] The dates to exclude from the count

WEEKNUMBER Function Correct Ans - Returns a number
representing the week of the year, 1-53, where 1 is the first week in the
year.
Sample Usage
WEEKNUMBER([Due Date]5)

,Syntax
WEEKNUMBER( date )
date
— The date from which to return the week of the year

WEEKDAY Function Correct Ans - Returns a number representing
the day of the week, 1-7, where Sunday equals 1
Sample Usage
WEEKDAY([Due Date]5)
Syntax
WEEKDAY( date )
date
— The date from which to return the day of the week

VLOOKUP Function Correct Ans - Looks up a value and returns a
corresponding value in the same row but from a different column.
Sample Usage
VLOOKUP("Task E", [Task Name]1:Done5, 2, false)
Syntax
VLOOKUP( search_value lookup_table column_num [ match_type ])
search_value
— The value to search for, which must be in the first column of
lookup_table.
lookup_table
— The cell range in which to search, containing both the search_value (in
the leftmost column) and the return value.
column_num
— A number representing the column position (in lookup_table) of the
value to return, with the leftmost column of lookup_table at position 1.
match_type
—[optional] The default is true. Specifies whether to find an exact match
(false) or an approximate match (true).

VALUE Function Correct Ans - Converts a text value that represents
a number into a number
Sample Usage
VALUE(LEFT(Cost5, 3)) * 4
Syntax
VALUE( text )

,text
— The text value to convert

UPPER Function Correct Ans - Converts lowercase characters in a
text string to uppercase
Sample Usage
UPPER("hello world!")
Syntax
UPPER( text )
text
— The string to convert to uppercase

UNICHAR Function Correct Ans - Converts a number into a Unicode
character.
Sample Usage
UNICHAR(169)
Syntax
UNICHAR( number )
number
— The number to convert into a Unicode character.

TOTALFLOAT Function Correct Ans - TotalFloat() function
calculates the number of days that a task can be delayed without impacting
the Project Finish Date.
Sample Usage
=TOTALFLOAT([Primary Column]@row)
Syntax
TOTALFLOAT( Value )
Value
— The row at which you would calculate the TotalFloat function

TODAY Function Correct Ans - Sample Usage
TODAY()
Syntax
TODAY([ number ])
number
—[optional] The number of days before (negative number) or after
(positive number) the current date

, SUMIFS Function Correct Ans - Adds numbers within a range when
all given conditions in their respective ranges are met.
Sample Usage
SUMIFS(Cost:Cost, Quantity:Quantity, >25, [Task Name]:[Task Name], "Task
A")
Syntax
SUMIFS( range criterion_range1 criterion1 [ criterion_range2criterion2... ])
range
— The group of cells to sum, assuming they meet all criteria.
criterion_range1
— The group of cells to be evaluated by the criterion.
criterion1
— The condition that defines which numbers to add; for example: 15,
"Hello World!", or >25.
criterion_range2
criterion2...
—[optional] Additional ranges and criteria to have evaluated.

SUM Function Correct Ans - Adds a series of numbers
Sample Usage
SUM(Cost1:Cost5)
Syntax
SUM( number1 [ number2... ])
number1
— The number or range of numbers to add
number2
...
—[optional] Additional numbers or ranges of numbers to add

SUCCESSORS Function Correct Ans - Used within another function
to calculate the direct successors of a task and return succeeding task row
number(s) that occur as a result of the referenced task.
Sample Usage
= JOIN(SUCCESSORS(Column@row),",")
Syntax
SUCCESSORS( value )
value
— The value, typically a cell to evaluate.