Smartsheet General 2024 – Questions & Solutions
Formulas: T/F When adding a row above or below a cell with a formula, the
cells automatically inherit a cell formula Correct Ans - TRUE -
When adding a row above or below a cell with a formula, the cells
automatically inherit a cell formula
Cell References can be added by clicking directly on the cell Correct
Ans - TRUE -Cell References can be added by clicking directly on the
cell
How do you separate cell references by using a cell range (same sheet)
Correct Ans - Use a colon separating the beginning and ending cell
references and add another range by separating with a comma (eg.
=[weighted Value]2:[Weighted Value]6, [weighted Value]10:[Weighted
Value]19 )
Formulas: T/F When adding a new child row, the new data is not added to
an existing formula Correct Ans - False - All children added to a
parent with a formula are automatically included in that data
Formula: What is a "range"? Correct Ans - Range from which we'll
find data we want to pull in or populate
If I have a "Contact List", can I add a formula to that column? Correct
Ans - Yes! Formulas can be placed in contact list fields
What does <> mean in a formula? Correct Ans - Not Equal To
Can a field contain a formula if it is a contact list that is also being used in
resource management? Correct Ans - No. Contact list fields that are
being used in resource management cannot contain a formula
T/F: System fields can contain a formula (i.e. "date created" or "latest
comment") Correct Ans - False - System fields cannot contain a
formula (for example, "modified by" or "latest comment")
, T/F Default columns cannot contain a formula Correct Ans - True -
Default columns (attachments, comments, row action indicator) cannot
contain a formula
T/F: A start date being used for dependencies and resource management
may not also contain a formula Correct Ans - TRUE - fields that are
being used in resource management or for dependencies cannot contain a
formula
T/F: A project end date being used for dependencies and resource
management may not also contain a formula Correct Ans - TRUE -
fields that are being used in resource management or for dependencies
cannot contain a formula
T/F: A "duration" being used for dependencies and resource management
may not also contain a formula Correct Ans - TRUE - fields that are
being used in resource management or for dependencies cannot contain a
formula
T/F: A Predecessor field being used for dependencies may also contain a
formula Correct Ans - FALSE - fields that are being used in resource
management or for dependencies cannot contain a formula
T/F: A % Complete being used for dependencies and resource management
may also contain a formula Correct Ans - FALSE - fields that are
being used in resource management or for dependencies cannot contain a
formula
T/F: A Form can have a formula Correct Ans - False - You cannot
create a formula with this feature
T/F: Update Requests can have a formula Correct Ans - False - You
cannot create a formula with this feature
T/F: Reports may not contain a formula Correct Ans - True -
Formula results can still be viewed in reports, but they can't contain
standalone formulas
Formulas: T/F When adding a row above or below a cell with a formula, the
cells automatically inherit a cell formula Correct Ans - TRUE -
When adding a row above or below a cell with a formula, the cells
automatically inherit a cell formula
Cell References can be added by clicking directly on the cell Correct
Ans - TRUE -Cell References can be added by clicking directly on the
cell
How do you separate cell references by using a cell range (same sheet)
Correct Ans - Use a colon separating the beginning and ending cell
references and add another range by separating with a comma (eg.
=[weighted Value]2:[Weighted Value]6, [weighted Value]10:[Weighted
Value]19 )
Formulas: T/F When adding a new child row, the new data is not added to
an existing formula Correct Ans - False - All children added to a
parent with a formula are automatically included in that data
Formula: What is a "range"? Correct Ans - Range from which we'll
find data we want to pull in or populate
If I have a "Contact List", can I add a formula to that column? Correct
Ans - Yes! Formulas can be placed in contact list fields
What does <> mean in a formula? Correct Ans - Not Equal To
Can a field contain a formula if it is a contact list that is also being used in
resource management? Correct Ans - No. Contact list fields that are
being used in resource management cannot contain a formula
T/F: System fields can contain a formula (i.e. "date created" or "latest
comment") Correct Ans - False - System fields cannot contain a
formula (for example, "modified by" or "latest comment")
, T/F Default columns cannot contain a formula Correct Ans - True -
Default columns (attachments, comments, row action indicator) cannot
contain a formula
T/F: A start date being used for dependencies and resource management
may not also contain a formula Correct Ans - TRUE - fields that are
being used in resource management or for dependencies cannot contain a
formula
T/F: A project end date being used for dependencies and resource
management may not also contain a formula Correct Ans - TRUE -
fields that are being used in resource management or for dependencies
cannot contain a formula
T/F: A "duration" being used for dependencies and resource management
may not also contain a formula Correct Ans - TRUE - fields that are
being used in resource management or for dependencies cannot contain a
formula
T/F: A Predecessor field being used for dependencies may also contain a
formula Correct Ans - FALSE - fields that are being used in resource
management or for dependencies cannot contain a formula
T/F: A % Complete being used for dependencies and resource management
may also contain a formula Correct Ans - FALSE - fields that are
being used in resource management or for dependencies cannot contain a
formula
T/F: A Form can have a formula Correct Ans - False - You cannot
create a formula with this feature
T/F: Update Requests can have a formula Correct Ans - False - You
cannot create a formula with this feature
T/F: Reports may not contain a formula Correct Ans - True -
Formula results can still be viewed in reports, but they can't contain
standalone formulas
