-
Activity Log - Is there a way to limit who sees it?
Is there a way to hide the activity log from users or limit the view? We make changes to Project Plans especially in the beginning where we don't want a client to see it. It could raise a lot of questions and concerns.
-
Smartsheet Asian Server
Hi Smartsheet team, Is it possible for you guys to provide server in asia? Smartsheet takes longer to load here in the Philippines. Thanks, Dennis
-
Linking rows
I would like to know how can I do to link 2 or more rows (primary and secondares) in such a way that when I click on the check box of the primary row, it checks in the secondary boxes automatically
-
Attempting a formula with multiple criteria
Hi, can anyone help with the formula for the following required outcomes? * $0 if the management agreement has not started [Mgnt Start Date], * Equal to the chargeable amount [chargeable amt] if the Management agreement has started ie [Mgnt Start Date] in the prior month * Equal to the previous month [Jan 17] if the…
-
Very annoying jira sync problem
Hi There, UPDATE: i tryed a other project and that did seem to work, so stories remained in the same position, disconnected from parent story or epic as intended. I think, my updates just never got synced. Am i correct when i say that when a story is allready present on the sheet, the position is not being updated, what i…
-
Smartsheet jira connector row issue
Hi all, I have a project sheet which is connected to jira. Everytime the connector gets updated some of the rows that i have arranged/sorted get moved in smarsheet. Is there a way where i can fix the rows in one place and only the fields can get updated when the connector is updated. The locking row option doesnt help…
-
Best way to set up a sheet to track multiple IT projects
Our IT department has several projects we want to track. I need advice on the best way to set up the sheet(s) so that we can see the details of each project and have the ability to see all of the projects on one sheet. Which option would be the better set-up? Option A - Have one sheet that lists of all the projects with…
-
How to Applying Conditional Formatting Efficiently Across Entire Sheet
Can you apply a conditional format of say "anytime the value '0' appears throughout the sheet, change its color to RED" efficiently or do you have to make one conditional rule per column for all the columns you have in the sheet? Additionally, is there an "OR" function within conditional formatting? For example, "If Column…
-
Default form date to Today + constant
I am creating a form that un licensed users will use to submit requests. I want the default for the form to be Today + 4 business days. Is this possible? It looks like the default date can either be hard coded to a specific date, or set to Today. Any help would be appreciated!
-
Use Today's Date by Default in Web Form
I've created a task list which I enter tasks via a web form. I have a Date Entered field in the web form. I would like to make this a hidden field in the web form and by default enter today's date into my task list when I submit the form.