SI.TASKNAME

Created by Damien Zwillinger, Modified on Tue, 13 Feb 2024 at 02: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

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article