Where can I find documentation for which operators Smartsheet supports in formulas? Note: I am looking for documentation of operands ("+", "&", "<", etc.) not functions (SUM, INT, MAX, etc.). For example, here is the page that documents which operands are supported by Excel:…
How to quickly link tasks in a project?
I know of two ways to do it in SmartSheet - drag and link in the Gantt chart, or manually set the predecessor of a task in the sheet. In MS Project you can select two or more tasks and easily link or unlink them using a menu, button or keyboard shortcut. Is there a similar way to link tasks in SmartSheet? (I'm hoping for a…
Working with Multiple Calendars, Vacation Days, and Weekend working days
In my project team, we have team members located in different parts of the globe. I need to link to the project non-US calendars and holidays aside from those of the US. Additionally, I need to enter the vacation days of all team members who has vacation plans or out days, and enter weekend working days when, say, a…
Cannot format Milestones & Summary bars
I'm trying to use conditional formatting to change the color of milestones within the GANTT view. I've created a rule that looks for tasks with zero duration, and has the word Begin or Complete in it, and I'm able to locate the tasks, and format the text, but I'm not able to format the Summary Bars or Milestone indicators.…
Hyperlink to Cell in same Sheet
How do I hyperlink a cell in the same Smartsheet?
Equivalent to the "Link the selected tasks" from MS Project?
Is there any way in Smartsheet to have selected tasks linked in series quickly so that one will start after another? All I found is you can: - Manually type the previous row's number in the predecessor column of each task - Link tasks, two at the time, using mouse in the Gantt chart. But first you have to place the same…
Greetings, I am a SharePoint admin for our company and would really like to know how others have integrated Smartsheet into their site. Right now we have an icon with a link to the page. It would be nice to have it go to a particular Smartsheet.
Vertical Text Alignment
For a multi column checksheet, I want to have the header text vertically aligned to keep the column width to the "X" width. Is there a method to accomplish this, it is that way in my spreadsheet but would not import correctly. Thanks Example P A R C O C P E O P S T E E D D X X
How can I reapply a sort (or filter) without having to re-enter it from scratch?
Refreshing the browser page doesn't do it. It would be great if there was a "Refresh" button somewhere.
Change Label in Calendar View
Is there a way to change the label in calendar view? In Gantt I can go to project: settings/Timeline Display/Display label for; then select which column.