-
IF(CONTAINS(OR( Help
Hi, I am trying to get the following to work: I have a Sales Order Column where I have 3 possible entries: A date (Ex: 31Aug2019), a 2DP Order (Ex: 11111-1), and a QC Order (Ex: 11111-1 QC). I have two hidden checkboxes that will give a check if an order is QC or 2DP. For QC, I just have =IF(CONTAINS("QC", [Sales…
-
Notifications using Summary Sheet
If I create an automation workflow to notify all contacts on a sheet, will those listed in the sheet summary be included?
-
Comments to all users that have access to a sheet
Hello community, is there a way to communicate to all users that have access to a sheet? I want to make an announcement to all people with access to a sheet via Smartsheet and not by e-mail but it seems that I can't find the right "button" within Smartsheet... Any idea? Best regards Dietrich
-
Tracking comments on reports?
Can comments on sheets or rows in sheet be pulled into a report? I'd like to see the most recent comments added to a sheet on a report of several sheets.
-
Limiting tasks (by name) to specific days of the week
Hi, I'm looking for a way to control specific tasks being allowed to start on only certain days of the week. For instance, a task name containing "A" is not allowed to occur on Mon or Fri, only possible to start/finish on Tue, Wed, or Thu. Keep in mind, A is a precedent for B, which is a precedent for C. But B and C are…
-
Gantt View - Limit Columns Shown
Hi, I'm trying to limit the columns shown in Gantt View. We have some cells that are reporting info from a link. Sometimes these values are very lengthy. 300 words? The problems is this makes each row very tall in Gantt view, and makes the schedule difficult to read. Hiding these column doesn't help. Is there a way to…
-
creating row report & summary report from 1 sheet
I love the new summary report option but I still want to be able to create a row report from the same sheet. I have already created a summary report but I also need to add a row report to my dashboard for the same sheet. I used the summary report to create a chart on my dashboard. I tried to create a row report but the…
-
Max Capacity error on sheet w/3,256 rows and 8 columns
I am getting the "this action could not be completed because your sheet as exceeded the maximum recommended size" error on a sheet that I don't think is at the maximum. I have 3,256 rows and 8 columns which, if my math is correct, is 26,048 cells, no where near 200,000. I got the error when trying to add another column.…
-
Report vertically versus horizontal
I'm setting up a new tracking sheet which will have multiple columns (about 50). For ease of displaying these to end users, I would like to 'report' them vertically. Is that possible in SmartSheets? FYI, the reason for now setting up vertically is to preserve field format (date versus text). For Example: Currently displays…
-
Auto Populating Drop Down List
New to SmartSheet, and want to use it to keep track of tasks. So, I created a "Project" column in my task list, and set it to a drop down, not limiting the entries to values in the list. What I am looking for is, that when I create a new task, and type a value to the Project column that doesn't exist on the list, that it's…
