-
How do you use the keyboard to move to the next cell in a row after selecting items in a drop-down
I'm challenge by this situation and the only way I have worked out how to do it is to use the mouse to click into another cell. What happens is, after I have made a selection of one or more options from a drop-down list, the following keyboard commands result in undesirable effects: Tab or Enter while mouse is hovering…
-
Employee In Take Form: Trying to auto check selections based on 1 and 2 column criteria.
I have many columns created with a checkbox. Ten columns are labeled as required devices for employee types. [Employee type column named "Role"] When a certain employee type is entered in the "Role" column the "Devices" column check boxes would be auto selected showing what devices are required for that Role. Example: If…
-
IF NOT ISBLANK help
I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patient is filled in but Order Request Date is blank, Green if Complete date is filled in,…
-
Salary Formula ( Calculation of Basic and commission)
Hi , I need formula for (Net Salary) col as follow : To Count the sum in Col (Basic Salary) Plus sum of 15% for amounts equal/less than 600 and sum of 25% for amounts more than 600) of the number in Col (Total Income) We Pay our Employee (ex. sales man) salary with compensation of basic salary PLUS markup commission as…
-
Send an email update to a row without direct email integration
Many project management and CRM tools I've used provide an email address for each project in order to use it to forward an email update directly to the row (or use the CC with this email so the email record goes directly into the row comments/conversation). Smartsheets should offer the ability to view the address (for…
-
Project status synchronization between 2 sheets
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
-
Monitoring Workload without Resource Add-On
Hello- I am managing a project in Smartsheet where I need the ability to conduct ongoing monitoring of resource hours for tasks per week. The use case is for the PM to use this info to ensure the estimated times of tasks assigned to a given individual don't exceed that person's availability cap (That data is stored…
-
Remove cell contacts, already removed from contact list, and sharing list, and culumn properties.
Hello, I've noticed that contact columns save, or cache, the contacts that have been previously entered in that column. If I begin typing a name, it will produce a drop-down menu that includes all of the contacts which have previously been used in that column and which also begin with the letters I've entered. For example;…
-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
-
Sheet Row Limit - Automation Recos / Suggestions
With one of our clients, we are running into the 20,000 sheet row limit, and I was wondering what others have done to work around this issue? My first instinct is to createduplicate a sheets, and then use a report to pull it altogether in the end. It's a pretty manual solution, so I'm looking for something more automated…