Sheet Name in Task Name

Chuck Kahn

Is there a way to display the Sheet Name in the Task Name or do I have type it in for each task?

J. Craig Williams

Chuck

 

Why do you need the sheet name in the task name?

(You could do it with a formula but would have to type the sheet name once)

 

Craig

J. Craig Williams

Chuck,

 

I think Calendar View can only display the text that is in the Primary column.

That means you'll need a formula to build that column's data.

 

If you move the contents of your Primary column (maybe you have renamed it "Tasks") to a new column (name it something like Raw Tasks)

 

If you have somewhere to put the sheet name (like if row 1 is empty), then you could use the [Raw Tasks]1 as your permanent sheet name.

 

Your Primary column would then be

 

=$[Raw Tasks]$1 + " " + [Raw Tasks]2

for row 2 and then copy that formula to the rest of the column.

 

Alternatively, you could add a column (call it [Sheet Name]) and put your sheet name there. I don't like that solution because you need to keep that column filled which can pose slight problems.

(The easiest way to resolve this is to have a formula there:

="sheet name"

instead of hard-coding your sheet name.

This will at least take advantage of auto-fill for new rows, usually)

 

If you go that route then each Primary column's formula would match this pattern:

 

=[Sheet Name]1 + " " + [Raw Tasks]1

 

Craig

 

Chuck Kahn

I'm converting a schedule table that has episodes in the row headers (101, 102, etc) and tasks in the column headers (shoot, editor cut due, director cut) and dates in the cells.  Because I can't fit all the episodes in one SmartSheet I've created a 101 sheet, a 102 sheet, etc.  Each sheet has the same task names. But for the calendar report to make sense, the task names would need the episode number appended to the task name. 

Chuck Kahn

That's great!  I didn't know that "+" could concatenate text.

 

I notice the result of 

 

=$[Raw Tasks]$1 + " " + [Raw Tasks]2

 

has empty spaces padding on the left of the text.  Not a big deal but it makes the column wider.

J. Craig Williams

Is there padding in the [Raw Tasks]1 cell?

 

Craig

Chuck Kahn

No padding in the Raw Tasks cell.  That's what makes the padding in the Task Name cell extra-noticeable.  They are side-by-side  The first character in the Task Name cell is under the "k" in "Task".

J. Craig Williams

What do you mean side-by-side?

If you type the same text in the Primary column instead of using the formula, you should see the same behavior.

It isn't padding, the text is the Primary column is slightly shifted to the right. I think that is a feature, but I'm not sure why.

 

Craig

 

 

Chuck Kahn

I mean that the Raw Text column is beside the Task Name column, so the indentation is easy to see by comparison with the two columns being side-by-side whereby one column is not indented and the other is indented.