-
Scheduled but not done formula
I have a data set that has a Schedule Date (attached screen shot of data), and there is a column that has a check box that is referencing that field. I send the Smartsjeet form to a user, and they put a check mark in the check box if they have completed. If that box is not checked, and the date is later than today, I would…
-
check box formula
Hello I am trying to do the following on my smartsheet. I have two columns : the first one with a checkbox format and the next column indicating the % completed. I want to create a condition such that, if the check box is ticked, the % complete indicates 100% else 0%(if not ticked). I used the following equation: IF(COL1 =…
-
Resource Management
Creating a Resource Management plan and hitting two snags: (1) Not all sheets are being accessed for the Resource plan butResource mgmt. is turned on in all sheets (2) Not all resources are being pulled from the worksheets. Unsure what "Users in your user account" means - how do I ensure all resources are being pulled into…
-
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…
