SI.TASKNAME
Created by Damien Zwillinger, Modified on Tue, 13 Feb at 2:40 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
The SI.TASKNAME function returns the task name corresponding to one or more given task IDs within a specified project.
TABLE OF CONTENTS
Syntax
SI.TASKNAME(Connection, ProjectID, TaskID)
Parameters
The SI. TASKNAME function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
ProjectID | Optional | The ID number of the project containing the task (if the ProjectID is left blank, the function returns the name of the Standard Task defined in Sage Intacct) |
TaskID | Required | The ID number of the task |
Examples
Example 1
=SI.TASKNAME("Sage", "20-001","G01-000")Description
Returns the name of the task with the ID G01-000 in project 20-001
Result
Example 2
=SI.TASKNAME("Sage", "20-001", B2:B4)Description
Returns the name of the tasks in project 20-001 whose ID numbers are listed in cell B2 through B4.
Result
Example 3
=SI.TASKNAME("Sage", "20-001",C2#)Description
Returns the name of all task names associated with project 20-001 whose ID numbers are displayed by the function in cell B2.
Result
(note: cell references have been used for some parameters in these examples)
Example 4 - Standard Task
If the ProjectID parameter is left blank, the function returns the name of the corresponding Standard Task defined in Sage Intacct
Given this configuration within Sage Intacct:
=SI.TASKNAME("Sage",,"500")Description
Returns the name of the Standard Task whose ID number is 500
Result
(note: cell references have been used for some parameters in this example)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article