-
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,…
-
Allow ISO 8601 Date format for dates (YYYY-MM-DD hh:mm:ss)
ISO 8601 is an international data standard and a part of two national standards in the United States. "The standard provides a well-defined, unambiguous method of representing calendar dates and times in worldwide communications, especially to avoid misinterpreting numeric dates and times when such data is transferred…
-
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…
-
Prevent Sorting on Shared Sheet
We have a lot of users using Smartsheet as a tracker. Team members sort and then filter to get the information they need. The problem is that the sort affects all of the other users who are sorting on different things. Is there a way to have the sort only apply to the user that is sorting? Similar to the way that filters…
-
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…
