-
Check Box and Conditional Formatting
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…
-
Accounts Receivable formulas for SmartSheet
Good morning, I am seeking formulas to help setup my accounts receivables SmartSheet based on the Status Stage from my project management sheet. Is there a formula for extracting from my "Invoiced" stage the cell history date from that cell. This is the date the status of that cell turned to "Invoiced". Then I will like a…
-
How to create Report/Chart/Sheet for overview of many?
We have a Sheet for every project. Every Sheet is basically a checklist. The checklists are similar but wording and order of the tasks are different. I want to create something that will bring in just the "Completed" checkbox and the Primary Column of each Sheet/checklist so that the overall status can be easily seen. How…
-
Text vs duration and dependencies
Hello everyone, I need to create an easy to use sheet that will allow my team to choose a task type from a drop down list that then auto-populates an SLA column and from that works out overallocation of resources. So far I have tried to do a VLOOKUP from the task type to our SLA times but that comes across as a text entry…
-
Referencing External Sheet Data
Is there any way to reference data in another sheet based on a cell's contents? I have inventories that have asset tags and associated serial numbers. I have a separate sheet for maintenance logging. Is it possible to type in an asset tag and have the corresponding serial number auto-fill in the adjacent column? Thanks!
-
Satisfy all requirements; with different formats of columns
Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete .. initially i think i need to use a countifs formula to tally all columns…
-
% Complete Based on Amount of Tasks, Not Time
Hi, New to Smartsheet, and wondering if there is a way to have the % complete cell calculated by the number of 'child' tasks only, rather than basing it on the amount of time each task takes to complete. For example, if I had 5 'child' tasks below 1 parent task, I want each one to be weighted equally at 20%, regardless of…
-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
-
Trying to Hyperlink an Email address
Hello! I am doing by best but cannot seem to figure out a way to hyperlink and email address within a cell so that it can immediately open a blank email if clicked. Is that possible? Thanks for your help!
-
Programatically select a subset of a column
I want to be able to average, or other function, over a subset of the cells in a row. The number of cells I want to include is specifiied in a separate cell. In Excel, I accomplished this with OFFSET. I read another article here noting that smartsheet doesn't have OFFSET, but that MATCH and INDEX might be able to be used…
