-
Card view - How to decide the "fastview" Columns?
Hi! When you go into card view and look at a card. You see the "Main collumn" as the card name but you also see 4 more columns without going into "edit". How do I decide what columns should be shown ON the card in card view? Kind Regards// Hugo Martinwall
-
Inconsistent format (mojibake) when exporting smartsheet Gantt to PDF
Hi, I created a Gantt with Smartsheet. Tasks names could be: - English characters only - Japanese characters only; and - a mixture of English and Japanese. When I exported the Gantt to PDF with: File => Export => Export to PDF I found that PDF generated sometimes show Mojibake (unreadable characters) when the task names…
-
Setting automatic update request based on field data
It looks like the automated update requests need data in the row (or in a column) to change before an update can be requested. I want to request updates on a given schedule - without having to manually request the update. Here's the situation - we have trainers in the field who create a new class using a form. The classes…
-
Count number of resources per project
Hi, I'm trying to count number of resources assigned to a project but I'm not sure how to go about it, when there is a duplicate. Meaning, if John Doe is assigned to 5 tasks, Jane Doe is assigned to 3 tasks, and Billy Bob is assigned to 1 task, is there a way to count the number of resources assigned to the project, which…
-
CHECKBOX CONDITIONAL
I have a task and few subtasks that have a column which is of checkbox format. I need to create a condition, such that, if all the check boxes for the subtasks are ticked, then the check box for the main task should also be ticked, else it should be left unchecked. I tried to apply the following: IF(AND(SUBTASK1:SUBTASK5)…
-
Avoid Overbooking a Training Facility
Hi, When creating a project grid for training events, I add a column named "Venue". In this column I provide the name of training facility where the training needs to be conducted. Hence, I need a way to be alerted when using the same venue more than one time on a specific day. Because, obviously, i cannot run two…
-
Analysis customer complaints
Hello experts, Our sales team registered customer complaints on the smart sheet , and we have detailed information about the complaints, name\ address\ depicted reason\ volume of Nonconformity etc. We want to have a summary chart or graph to summary the monthly situations. Where I can find some this kind of video…
-
Reporting on Activity Log data without exporting to excel
I am looking for a method to query/report on activity log data without exporting to excel and then importing back I into smartsheet. For example: I need to expose via a Dashboard the number of times specific Dashboards and Sheets are being accessed. Currently activity logs are exported to excel; a pivot table is created to…
-
Parent Rows
Is there a way to remove the Start Date, End Date, and Duration from a parent row without Disabling Dependencies? We have an Alert set for the day after a due date in a column that has an unchecked Complete box. We are receiving alerts for our Parent columns which are not actual tasks. We could add a condition that the row…
-
Dependencies & Predecessor Dates
Hello, I am having trouble with predecessor dates. I would like the duration and dates to be set automatically for line 10 as Rows 9 and Rows 17 change to accommodate variables. I'd like the date to load as one day after the Finish Date of row 9, and end one day before the begin date of row 17. It isn't working out that…
