Smartsheet Training

SMARTSHEET

TROUBLESHOOTING

"IF" function

Multiple Choice

Formula in "Remarks" column:

=IF(Status3 = "red", "at risk", "on-time")

What will be the result?

• Red

• at risk

• on-time

• #Invalid

Multiple Choice

Formula in "Delivery Charge" column:

=IF([Delivered?]5 = true, "paid", "pending")

What will be the result?

• paid

• pending

• #invalid

• true

• false

Multiple Choice

Formula in "Status" column:

=IF([Order Date]2 < TODAY(), "Red", IF([Order Date]2 > TODAY(), "Yellow", IF([Order Date]2 = TODAY(), "Green")))

Note: "Date today" is Nov 29. What will be the result?

• Red

• Yellow

• Green

• Orange

Open Ended

Faulty row: [Approval Status]82

The task is approved but the approval status column shows that is for revision. How to fix it?

Open Ended

Faulty row: [Submission Status]82

The task has been submitted but "NA" is shown in the Submission Status column. The result should be "On-time". How to fix it?

Open Ended

Faulty row: [AC (PHP)]2

The UO task has been submitted and approved but no AC is reflected. How to fix it?

Open Ended

Faulty row: [AC (PHP)]3

The TGSA task has been submitted and rated but no AC is reflected. How to fix it?

SMARTSHEET

TROUBLESHOOTING

"vlookup" function

Open Ended

Bank name is incorrect even if the bank's name is included in the cross-sheet reference. How to fix it?

Open Ended

The account number of FRL-0329 is not reflected. How to fix it?

Open Ended

TIN is incorrect even if the TIN number is included in the cross-sheet reference. How to fix it?

Open Ended

The address of FRL-0329 cannot be found. How to fix it?

SMARTSHEET

TROUBLESHOOTING

"index" function

Open Ended

Formula:

=INDEX([Learning Competencies]1:[Lesson Code UO]10, 1, 2)

What value will the smartsheet return?

Open Ended

Formula:

=INDEX([Learning Competencies]1:[Lesson Code UO]10, 11, 2)

What value will the smartsheet return?

Open Ended

Formula:

=INDEX([Learning Competencies]1:[Learning Competencies]14, 1, 3)

What value will the smartsheet return?

SMARTSHEET

TROUBLESHOOTING

"index-collect" function

Open Ended

“Abi” is assigned as writer of unit 6 TGSA but not reflected in the task management sheet. How to fix it?

Open Ended

Elai is assigned to do DRRR 11/12 Q2 06 FDIA but not reflected in task mgmt sheet. How to fix it?

Open Ended

Steven is assigned to do DRRR 11/12 Q2 06 EDIA but not reflected in task mgmt sheet. How to fix it?