Exam (elaborations)
Smartsheet Formulas (Formulas Smartsheet) – Q&A
- Course
- Smartsheet Certification
- Institution
- Smartsheet Certification
Smartsheet Formulas (Formulas Smartsheet) – Q&A
[Show more]
Content preview
Smartsheet Formulas (Formulas Smartsheet) – Q&AYEARDAY 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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Studyhall. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for CA$26.62. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
83614 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now