-
Update a date field when the status in another column changes
Hi there, I need to have a date field update whenever I change the value in a dropdown field in another column. Can you help me with that? I'm very new to Smartsheet and the answers I've seen in similar questions are a bit over my head with the level of detail. If there are step by step instructions somewhere that would be…
-
Join Function + Date
Hello, I am trying to have row 1 reflect the outcome stated below and am struggling to get the right formula. I am currently using =JOIN(CHILDREN(), DATEONLY([Start Date]@row)) but want the start dates to reflect each of the corresponding Start Dates with Descriptions from the child row -- not the parent row. You can see…
-
Range with row numbers derived from another cell
Hi all! If I refer to a range as [D1]6:[D1]8 in a SUM (where my column id is D1 and the range contains rows 6,7,8), is there a way to replace the hard-coded 6 and 8 by values stored in another cell. For example, let's say [code]1 contains 6. Is there way to use that value of the cell [code]1 inside the formula: [D1][code]1…
-
How to compare data from 2 separate sheets to return a list of the differences
I have data contained in two sheets that two different team use, but there is a common identifying number column in both sheets. I wish to return a list the differences in these columns in a separate report or sheet
-
How to split a multiselection dropdwn Column to various single columns
Hi, I am sending a form for customers, and they have to select the regions when they want to have a service. Once I received their selections, I need to split the multiselections dropdown column to different column containing the different regions selected but individually to be able to send specific notifications for…
-
forecast formula for projection
I'm trying to have a cell provide me with a projected fee spent in $ in the forecasted $ column based on the remaining % of completion Any help or guidance would be much appreciated!!!
-
Project Health Formula Help
Hello, I've been struggling with this formula. I borrowed parts from other project tracking templates, but I can't seem to get everything to work together; I keep getting error messages. I'm looking to: Project Health turns "Green" for any row that has a Status of "Complete" or if the Target End Date is 1 week out or…
-
Using VLOOKUP to return Summary (Epic Name) from another Smartsheet
Hello SS Community, I'm trying to use a VLOOKUP to grab the Summary name of the Epic for all linked Issues, but keep getting an 'Invalid Reference' error. Can you point out what I'm doing wrong? Below is the original sheet w/formula and below that is the VLOOKUP sheet I'm referencing. Thanks so much! -kerri
-
SUMIFS Formula with Does Not Contain
I am creating a number of data sheets that will be the data for various Dashboard objects. I have a master data file that lists all customers, Status, Pipeline $, etc. (Sales Pipeline Data Sheet) In my current sheet, I am trying to enter a formula that will sum the total Pipeline $ for each Customer, along with the…
-
Multiple Values in One Column to RYG Balls
Hi all, Thanks in advance for any help you may be able to lend. I am working on a formula where I have several different values in one column that would correspond to different balls. Not Eligible, Not in Scope, Completed = Green Not Started, Request Submitted, Demo Scheduled, Cancelled, TBD = Grey Pending Assessment,…