-
Problem with formula in checkbox.
I have a formula in a cell check box: =IF(COUNTIF(b3:b4, true) > 0, true, false) It works great, but when you click on it, the formula is removed. It can be pressed accidentally, so I would like to protect myself. Nothing checked.^|^ Only Monday3 is checked, and also Monday2 checked automatically. ^|^ I checked Monday2,…
-
Error Code 18
Does anyone know what we may be getting this error code or how to fix it? formName: ajax formAction: fa_gridSave serverStatus: false serverStatusText: CriticalException errorCode: 18
-
Anyone else having a problem with wrong start and end dates today?
I came to work this morning to a schedule that looks destroyed. Many tasks that are 1d in duration are now showing up as two days, not sure if I should spend the next 8 hours fixing everything manually, or if it is a Smartsheet problem that will be corrected...
-
Workflows
Hello Community, I'm creating a workflow to alert someone in the "Send to Contacts in a cell", but I'm only able to select very few columns and it's not showing the columns/cells I wanted to select. Can someone help me please. Thanks, Preetham.
-
Granting access to workspaces
Who grants access to workspaces/sheets? Staff A (admin) shared a workspace with Staff B, but the email to allow access to the workspace for Staff B came to me (owner). Can't Staff A who is admin of the workspace allow them to view it? Why did I only get the email and not anyone who is assigned at Admin status or higher?
-
Global contact list
Our company has many logins to use smartsheet, but we want to have the same contact list when adding names to a contact field on smartsheet. For example, when I add a contact to a contact field on a sheet, I can select from a list of contacts that only I have added (see image). If another staff member goes to that sheet,…
-
FTE Calculations
Is there a way to track FTE resources using a percentage of their time for a specific task for a specific duration? When you assign a person to a task, Smartsheet seems always calculate a full resource rather than just a small percentage of that person's time. Because of that, our resources are always showing as…
-
How can I use one type in cells if the column is another type?
I need to use formulas on the top row and all following should be a checkbox. But when inserting a formula, a Boolean is expected. There a way to get around this somehow? Or can you suggest another way to implement the table?
-
Method for building a chart from a batch among multiple sheets
I have a single sheet of assignments (2 columns, just the batch # and the item). Each member of my team has a data entry sheet to fill out when they receive their items to work (over 50 sheets total). I am needing a way to chart percentages of final outcomes (completed, cancelled or already done) for a specific batch. It…
-
Nested Form Logic?
Good Afternoon Smartsheet Pros! I am trying to create a form that adds new employee data to a spreadsheet. My desire is that I have functionality that allows the form filler to add multiple personel entries to the same form. My instinct was to create an 'Add Additional Employee' checkbox with logic that populates the data…
